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_IE_PAYPATH_TAPE dependencies on PAY_MAGTAPE_GENERIC

Line 29: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')

25: p PER_PEOPLE_F_PK ,
26: oea PAY_EXTERNAL_ACCOUNTS_PK,
27: pea PAY_EXTERNAL_ACCOUNTS_PK)
28: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,hou,org) */
29: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')
30: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140
31: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYDDD')
32: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
33: ,'RECEIVER_ID=P' ,org.org_information9

Line 31: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYDDD')

27: pea PAY_EXTERNAL_ACCOUNTS_PK)
28: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,hou,org) */
29: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')
30: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140
31: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYDDD')
32: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
33: ,'RECEIVER_ID=P' ,org.org_information9
34: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
35: ,'FILE_FORMAT=P' ,nvl(org.org_information11, 'AIB')

Line 32: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')

28: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,hou,org) */
29: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')
30: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140
31: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYDDD')
32: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
33: ,'RECEIVER_ID=P' ,org.org_information9
34: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
35: ,'FILE_FORMAT=P' ,nvl(org.org_information11, 'AIB')
36: ,'EXPIRATION_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')

Line 34: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')

30: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140
31: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYDDD')
32: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
33: ,'RECEIVER_ID=P' ,org.org_information9
34: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
35: ,'FILE_FORMAT=P' ,nvl(org.org_information11, 'AIB')
36: ,'EXPIRATION_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
37: FROM
38: pay_payroll_actions ppa

Line 36: ,'EXPIRATION_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')

32: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
33: ,'RECEIVER_ID=P' ,org.org_information9
34: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
35: ,'FILE_FORMAT=P' ,nvl(org.org_information11, 'AIB')
36: ,'EXPIRATION_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
37: FROM
38: pay_payroll_actions ppa
39: , pay_assignment_actions paa
40: , pay_pre_payments ppp

Line 53: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

49:
50: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464
51: where
52: ppa.payroll_action_id = -- Bug No 3513042
53: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
54: and paa.payroll_action_id = ppa.payroll_action_id
55: and ppp.pre_payment_id = paa.pre_payment_id
56: and oea.external_account_id = popm.external_account_id
57: and popm.org_payment_method_id = ppp.org_payment_method_id

Line 122: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

118: , pay_external_accounts oea
119: , pay_external_accounts pea
120: , hr_organization_information org
121: where ppa.payroll_action_id = -- Bug No 3513042
122: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
123: and ppp.pre_payment_id = paa.pre_payment_id
124: and paa.payroll_action_id = ppa.payroll_action_id
125: and oea.external_account_id = popm.external_account_id
126: and popm.org_payment_method_id = ppp.org_payment_method_id

Line 199: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

195: , pay_external_accounts oea
196: , pay_external_accounts pea
197: , hr_organization_information org
198: where ppa.payroll_action_id = -- Bug No 3513042
199: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
200: and ppp.pre_payment_id = paa.pre_payment_id
201: and paa.payroll_action_id = ppa.payroll_action_id
202: and oea.external_account_id = popm.external_account_id
203: and popm.org_payment_method_id = ppp.org_payment_method_id