DBA Data[Home] [Help]

APPS.PAY_NZ_EFT dependencies on PAY_MAGTAPE_GENERIC

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

46: ||oea.segment3 -- account_no
47: ,'CLIENT_SHORT_NAME=P' -- BG Name
48: ,nvl(replace(o.name,','),'NULL VALUE')
49: ,'DUE_DATE=P'
50: ,to_char(to_date(pay_magtape_generic.get_parameter_value('TRANSACTION_DATE'),'YYYY/MM/DD'),'ddmmyy')
51: ,'HASH_TOTAL=P'
52: ,to_char(SUM(pea.segment2) + SUM(substr(pea.segment1,3,4)))
53: ,'BATCH_COUNT=P'
54: ,to_char(COUNT(*))

Line 73: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

69: , hr_organization_units o
70:
71: where
72: ppa.payroll_action_id =
73: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
74: and
75: ppp.pre_payment_id = paa.pre_payment_id
76: and paa.payroll_action_id = ppa.payroll_action_id
77: and ppa.business_group_id = popm.business_group_id --Bug 3719858

Line 150: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

146: , per_people_f p
147: , hr_organization_units o
148: where
149: ppa.payroll_action_id =
150: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
151: and ppp.pre_payment_id = paa.pre_payment_id
152: and paa.payroll_action_id = ppa.payroll_action_id
153: and ppa.business_group_id = popm.business_group_id --Bug 3719858
154: and oea.external_account_id = popm.external_account_id