DBA Data[Home] [Help]

APPS.PAY_SE_EFT dependencies on PAY_MAGTAPE_GENERIC

Line 18: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value

14: ,'PROCESS_DATE=P'
15: ,fnd_date.canonical_to_date(pay_se_eft.get_parameter(ppa.payroll_action_id,
16: 'PROCESS_DATE'))
17: from pay_payroll_actions ppa
18: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value
19: ('PAYROLL_ACTION_ID');
20:
21: /********************************************************
22: * Cursor to fetch Footer1 record information *

Line 81: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

77: pay_all_payrolls_f pap,
78: hr_organization_information hoi2,
79: hr_organization_information hoi3,
80: hr_organization_information hoi4
81: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
82: and ppa.business_group_id =ou.business_group_id
83: and paf.business_group_id=ou.business_group_id
84: and ppp.pre_payment_id = paa.pre_payment_id
85: and paa.payroll_action_id = ppa.payroll_action_id

Line 138: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value(

134: pay_assignment_actions paa,
135: per_all_assignments_f paf,
136: per_all_people_f pef,
137: hr_soft_coding_keyflex hsk
138: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value(
139: 'PAYROLL_ACTION_ID')
140: and ppa.payroll_action_id = paa.payroll_action_id
141: and paa.assignment_id = paf.assignment_id
142: and paf.payroll_id = nvl(ppa.payroll_id,paf.payroll_id )

Line 164: and hoi1.organization_id=pay_magtape_generic.get_parameter_value(

160: WHERE o1.business_group_id = ppa.business_group_id
161: and o1.organization_id = hoi1.organization_id
162: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
163: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
164: and hoi1.organization_id=pay_magtape_generic.get_parameter_value(
165: 'TRANSFER_ORGANIZATION_ID')
166: and hoi1.organization_id = hoi2.organization_id
167: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNITS'
168: );