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

Line 43: , pay_magtape_generic.get_parameter_value('FIRST_PARTY_REFERENCE')

39: , oea.segment2 ||lpad(substr(oea.SEGMENT3,1,9),9,' ')
40: , 'PAYMENT_CODE=P'
41: , NVL(popm.pmeth_information1,'NULL_VALUE')
42: , 'FIRST_PARTY_REFERENCE=P'
43: , pay_magtape_generic.get_parameter_value('FIRST_PARTY_REFERENCE')
44: , 'VALUE_DATE=P'
45: , to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSACTION_DATE'),'YYYY/MM/DD'),'ddmmyy')
46: , 'INPUT_MEDIUM=P'
47: , 'K'

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

41: , NVL(popm.pmeth_information1,'NULL_VALUE')
42: , 'FIRST_PARTY_REFERENCE=P'
43: , pay_magtape_generic.get_parameter_value('FIRST_PARTY_REFERENCE')
44: , 'VALUE_DATE=P'
45: , to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSACTION_DATE'),'YYYY/MM/DD'),'ddmmyy')
46: , 'INPUT_MEDIUM=P'
47: , 'K'
48: , 'FILE_NAME=P'
49: , '********'

Line 76: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

72: , per_assignments_f a
73: , per_people_f p
74: where
75: paa.payroll_action_id =
76: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
77: and ppp.pre_payment_id = paa.pre_payment_id
78: and paa.payroll_action_id = ppa.payroll_action_id
79: and oea.external_account_id = popm.external_account_id
80: and popm.org_payment_method_id = ppp.org_payment_method_id

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

89: group by oea.segment1
90: , oea.segment2 ||lpad(substr(oea.SEGMENT3,1,9),9,' ')
91: , popm.pmeth_information1
92: , oea.segment4
93: , to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSACTION_DATE'),'YYYY/MM/DD'),'ddmmyy')
94: , nvl(popm.pmeth_information7,'NULL')
95: , to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSACTION_DATE'),'YYYY/MM/DD'),'ddmmyy')
96: , popm.pmeth_information1
97: , popm.pmeth_information3

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

91: , popm.pmeth_information1
92: , oea.segment4
93: , to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSACTION_DATE'),'YYYY/MM/DD'),'ddmmyy')
94: , nvl(popm.pmeth_information7,'NULL')
95: , to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSACTION_DATE'),'YYYY/MM/DD'),'ddmmyy')
96: , popm.pmeth_information1
97: , popm.pmeth_information3
98: , popm.pmeth_information2
99: , popm.pmeth_information4

Line 142: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

138: , per_assignments_f a
139: , per_people_f p
140: where
141: paa.payroll_action_id =
142: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
143: and ppp.pre_payment_id = paa.pre_payment_id
144: and paa.payroll_action_id = ppa.payroll_action_id
145: and oea.external_account_id = popm.external_account_id
146: and popm.org_payment_method_id = ppp.org_payment_method_id

Line 156: order by decode(pay_magtape_generic.get_parameter_value('SORT_SEQUENCE'),'N',

152: and ppa.effective_date between pppm.effective_start_date and pppm.effective_end_date
153: and ppa.effective_date between a.effective_start_date and a.effective_end_date
154: and ppa.effective_date between p.effective_start_date and p.effective_end_date
155: and ppa.effective_date between popm.effective_start_date and popm.effective_end_date
156: order by decode(pay_magtape_generic.get_parameter_value('SORT_SEQUENCE'),'N',
157: pea.SEGMENT4,'B', pea.segment2)
158: ;
159:
160: end pay_hk_eft;