APPS.PAY_PYUCSLIS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 6096: from pay_payroll_actions pa1

6092: hr_utility.set_location('Entering : '||l_proc,10);
6093: select pay_core_utils.get_parameter('GENERATION_SCOPE',
6094: pa1.legislative_parameters)
6095: into l_generation_scope
6096: from pay_payroll_actions pa1
6097: where payroll_action_id = pactid;
6098:
6099: /*
6100: ** Define the SQL statement to get the people we want to process. Provide

Line 6109: ,pay_payroll_actions ppa

6105: then
6106: hr_utility.set_location(l_proc,20);
6107: sqlstr := 'select distinct per.person_id
6108: from per_all_people_f per
6109: ,pay_payroll_actions ppa
6110: where ppa.payroll_action_id = :payroll_action_id
6111: order by per.person_id';
6112: -- and ppa.effective_date between per.effective_start_date
6113: -- and per.effective_end_date

Line 6121: ,pay_payroll_actions ppa

6117: */
6118: hr_utility.set_location(l_proc,30);
6119: sqlstr := 'select distinct per.person_id
6120: from per_all_people_f per
6121: ,pay_payroll_actions ppa
6122: where ppa.payroll_action_id = :payroll_action_id
6123: and pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'',
6124: ppa.legislative_parameters) =
6125: per.business_group_id

Line 6172: ,pay_payroll_actions ppa

6168: stperson number,
6169: endperson number) is
6170: select distinct ppf.person_id
6171: from per_person_type_usages_f ppf
6172: ,pay_payroll_actions ppa
6173: ,per_person_types ppt
6174: where ppf.person_id between stperson and endperson
6175: and ppa.payroll_action_id = pactid
6176: -- and ppf.person_type_id = ppt.person_type_id --commented Bug6809753

Line 6256: ,pay_payroll_actions ppa

6252: endperson number) is
6253: select distinct asg.assignment_id,
6254: asg.person_id
6255: from per_all_assignments_f asg
6256: ,pay_payroll_actions ppa
6257: where asg.assignment_type in ('E','A','C')
6258: and asg.person_id between stperson and endperson
6259: and ppa.payroll_action_id = pactid
6260: and ( pay_core_utils.get_parameter('BUSINESS_GROUP_ID',

Line 6297: from pay_payroll_actions ppa

6293: ppa.legislative_parameters),
6294: pay_core_utils.get_parameter('WHO_TO_PROCESS',
6295: ppa.legislative_parameters)
6296: into l_business_group_id, l_generation_scope, l_who_to_proc
6297: from pay_payroll_actions ppa
6298: where ppa.payroll_action_id = pactid;
6299:
6300: /*********************************
6301: ** If terminated people selected

Line 6455: from pay_payroll_actions ppa,

6451: ppa.legislative_parameters),
6452: pay_core_utils.get_parameter('WHO_TO_PROCESS',
6453: ppa.legislative_parameters)
6454: into l_business_group_id, l_generation_scope, l_who_to_process
6455: from pay_payroll_actions ppa,
6456: pay_assignment_actions paa
6457: where ppa.payroll_action_id = paa.payroll_action_id
6458: and paa.assignment_action_id = p_assactid;
6459: