ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2EC3869E053B46B63588994Y select to_number(paa.serial_number) "Cheque_number", per.last_name, per.first_name, per.middle_names, ppf.payroll_name "Payroll name", ppa.effective_date "Effective date", per.employee_number, paf.assignment_number, ppp.value "Amount", ppp.personal_payment_method_id, ppa.date_earned, PAY_PAYIECHL_XMLP_PKG.report_dateformula() report_date, PAY_PAYIECHL_XMLP_PKG.payeeformula(ppp.personal_payment_method_id, ppa.date_earned, per.last_name, per.first_name, per.middle_names) Payee, PAY_PAYIECHL_XMLP_PKG.EMPLOYEE_NAMEFORMULA(per.last_name,per.first_name,per.middle_names) Employee_name from pay_payrolls_f ppf, per_people_f per, pay_pre_payments ppp, pay_payroll_actions ppa, pay_assignment_actions paa, per_assignments_f paf where not exists ( select 1 from pay_action_interlocks lck, pay_assignment_actions void_aa, pay_payroll_actions void_pa where lck.locked_action_id = paa.assignment_action_id and lck.locking_action_id = void_aa.assignment_action_id and void_aa.payroll_action_id = void_pa.payroll_action_id and void_pa.action_type = 'D' ) and ppa.payroll_action_id = :PACTID and paa.payroll_action_id = ppa.payroll_action_id and paa.action_status not in ('V', 'E') and paa.pre_payment_id = ppp.pre_payment_id and paa.assignment_id = paf.assignment_id and paf.payroll_id = ppf.payroll_id and paf.person_id = per.person_id and ppa.effective_date between paf.effective_start_date and paf.effective_end_date and ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date and ppa.effective_date between per.effective_start_date and per.effective_end_date &P_SORT_ORDER_T PAY PAYIECHL_XML US PAY IE Cheque Listing Application: Payroll Source: IE Cheque Listing (XML) Short Name: PAYIECHL_XML DB package: PAY_PAYIECHL_XMLP_PKG BI Publisher &p_sort_order_t :p_conc_request_id :p_sort_order :p_sort_order_t :pactid 1 10 :pactid LOV Oracle PY_SRS_IE_CHEQUE_RUN Y select action.payroll_action_id id, to_char(action.effective_date,'DD-MON-YYYY')||' ('||to_char(action.payroll_action_id)||')' value, null description from pay_consolidation_sets con,pay_payroll_actions action,pay_payrolls_f payroll,hr_lookups cheque_style where action.action_type='H' and action.current_task is null and action.business_group_id=fnd_global.per_business_group_id and action.payroll_id=payroll.payroll_id (+) and (payroll.payroll_id is null or action.effective_date between payroll.effective_start_date and payroll.effective_end_date) and cheque_style.lookup_type in ('CHEQUE_REPORT','IE_CHEQUE_REPORT') and cheque_style.lookup_code=action.cheque_report and action.consolidation_set_id=con.consolidation_set_id order by action.effective_date desc,action.action_sequence desc Y US Payroll Run 2 20 :p_sort_order LOV Oracle PY_SRS_IE_CHEQLIST_SORT Y select lookup_code id, lo.meaning value, null description from hr_lookups lo,fnd_sessions fnd where lo.lookup_type='IE_CHEQLIST_SORT' and fnd.session_id=userenv('sessionid') and lo.enabled_flag='Y' and fnd.effective_date between nvl(start_date_active,fnd.effective_date) and nvl(end_date_active,fnd.effective_date) order by lo.meaning select meaning from hr_lookups where lookup_type = 'IE_CHEQLIST_SORT' and lookup_code = '1' Y US Sort Sequence