eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_EFT dependencies on PAY_MAGTAPE_GENERIC

Line 54: , to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSACTION_DATE'),'YYYY/MM/DD'),'ddmmyy')

50: , popm.pmeth_information8
51: , 'INDICATOR=P'
52: , nvl(popm.pmeth_information7,'NULL')
53: , 'TRANSACTION_DATE=P'
54: , to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSACTION_DATE'),'YYYY/MM/DD'),'ddmmyy')
55: -- Transaction Date
56: , 'BANK_MNEMONIC_CODE=P'
57: , popm.pmeth_information1
58: , 'REEL_SEQUENCE_NUMBER=P'

Line 79: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

75: , pay_payroll_actions ppa
76: , pay_payrolls_f ppf
77: where
78: ppa.payroll_action_id =
79: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
80: and oea.external_account_id = popm.external_account_id
81: and popm.org_payment_method_id = ppa.org_payment_method_id
82: and ppa.effective_date between popm.effective_start_date and popm.effective_end_date
83: and ppa.effective_date between ppf.effective_start_date(+) and ppf.effective_end_date(+)

Line 151: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') /bug 2900104/

147: , pay_assignment_actions paa
148: , pay_payroll_actions ppa
149: , per_assignments_f a /*bug 2900104*/
150: , per_people_f p
151: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') /*bug 2900104*/
152: and paa.payroll_action_id = ppa.payroll_action_id
153: and ppp.pre_payment_id = paa.pre_payment_id
154: and popm.org_payment_method_id = ppp.org_payment_method_id
155: and oea.external_account_id = popm.external_account_id

Line 165: order by decode(pay_magtape_generic.get_parameter_value('SORT_SEQUENCE'),'N',nvl(p.order_name,p.full_name),'B', pea.segment1 )

161: and ppa.effective_date between pppm.effective_start_date and pppm.effective_end_date
162: and ppa.effective_date between a.effective_start_date and a.effective_end_date
163: and ppa.effective_date between p.effective_start_date and p.effective_end_date
164: and ppa.effective_date between popm.effective_start_date and popm.effective_end_date
165: order by decode(pay_magtape_generic.get_parameter_value('SORT_SEQUENCE'),'N',nvl(p.order_name,p.full_name),'B', pea.segment1 )
166: ;
167: /*
168: ** Cursor to retrieve Westpac Direct Entry system control info
169: */

Line 185: (SELECT pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') payroll_action_id FROM dual WHERE rownum=1) ppas