APPS.PAY_PYUCSLIS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 3099: from pay_payroll_actions pa1

3095: hr_utility.set_location('Entering : '||l_proc,10);
3096: select pay_core_utils.get_parameter('GENERATION_SCOPE',
3097: pa1.legislative_parameters)
3098: into l_generation_scope
3099: from pay_payroll_actions pa1
3100: where payroll_action_id = pactid;
3101:
3102: /*
3103: ** Define the SQL statement to get the people we want to process. Provide

Line 3112: ,pay_payroll_actions ppa

3108: then
3109: hr_utility.set_location(l_proc,20);
3110: sqlstr := 'select distinct per.person_id
3111: from per_all_people_f per
3112: ,pay_payroll_actions ppa
3113: where ppa.payroll_action_id = :payroll_action_id
3114: order by per.person_id';
3115: -- and ppa.effective_date between per.effective_start_date
3116: -- and per.effective_end_date

Line 3124: ,pay_payroll_actions ppa

3120: */
3121: hr_utility.set_location(l_proc,30);
3122: sqlstr := 'select distinct per.person_id
3123: from per_all_people_f per
3124: ,pay_payroll_actions ppa
3125: where ppa.payroll_action_id = :payroll_action_id
3126: and pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'',
3127: ppa.legislative_parameters) =
3128: per.business_group_id

Line 3175: ,pay_payroll_actions ppa

3171: stperson number,
3172: endperson number) is
3173: select distinct ppf.person_id
3174: from per_person_type_usages_f ppf
3175: ,pay_payroll_actions ppa
3176: ,per_person_types ppt
3177: where ppf.person_id between stperson and endperson
3178: and ppa.payroll_action_id = pactid
3179: -- and ppf.person_type_id = ppt.person_type_id --commented Bug6809753

Line 3259: ,pay_payroll_actions ppa

3255: endperson number) is
3256: select distinct asg.assignment_id,
3257: asg.person_id
3258: from per_all_assignments_f asg
3259: ,pay_payroll_actions ppa
3260: where asg.assignment_type in ('E','A','C')
3261: and asg.person_id between stperson and endperson
3262: and ppa.payroll_action_id = pactid
3263: and ( pay_core_utils.get_parameter('BUSINESS_GROUP_ID',

Line 3300: from pay_payroll_actions ppa

3296: ppa.legislative_parameters),
3297: pay_core_utils.get_parameter('WHO_TO_PROCESS',
3298: ppa.legislative_parameters)
3299: into l_business_group_id, l_generation_scope, l_who_to_proc
3300: from pay_payroll_actions ppa
3301: where ppa.payroll_action_id = pactid;
3302:
3303: /*********************************
3304: ** If terminated people selected

Line 3458: from pay_payroll_actions ppa,

3454: ppa.legislative_parameters),
3455: pay_core_utils.get_parameter('WHO_TO_PROCESS',
3456: ppa.legislative_parameters)
3457: into l_business_group_id, l_generation_scope, l_who_to_process
3458: from pay_payroll_actions ppa,
3459: pay_assignment_actions paa
3460: where ppa.payroll_action_id = paa.payroll_action_id
3461: and paa.assignment_action_id = p_assactid;
3462: