DBA Data[Home] [Help]

APPS.HR_NONRUN_ASACT dependencies on PAY_ALL_PAYROLLS_F

Line 3926: pay_all_payrolls_f pay,

3922: act.assignment_action_id,
3923: act.assignment_id,
3924: act.tax_unit_id
3925: from pay_payroll_actions pa1,
3926: pay_all_payrolls_f pay,
3927: per_time_periods ptp,
3928: pay_payroll_actions pa2,
3929: pay_action_classifications pcl,
3930: pay_population_ranges pop,

Line 3993: pay_all_payrolls_f pay,

3989: act.assignment_action_id,
3990: act.assignment_id,
3991: act.tax_unit_id
3992: from pay_payroll_actions pa1,
3993: pay_all_payrolls_f pay,
3994: per_time_periods ptp,
3995: pay_payroll_actions pa2,
3996: pay_action_classifications pcl,
3997: per_periods_of_service pos,

Line 5072: multi_asg_fg pay_all_payrolls_f.multi_assignments_flag%type;

5068: stperson number;
5069: endperson number;
5070: chunk number;
5071: rand_chunk number;
5072: multi_asg_fg pay_all_payrolls_f.multi_assignments_flag%type;
5073: l_use_pop_person number := use_pop_person;
5074: begin
5075: pay_core_utils.get_action_parameter('SET_DATE_EARNED',
5076: g_set_date_earned,

Line 5090: from pay_all_payrolls_f prl,

5086: return ;
5087: elsif (atype = PREPAY) then
5088: select nvl(multi_assignments_flag, 'N')
5089: into multi_asg_fg
5090: from pay_all_payrolls_f prl,
5091: pay_payroll_Actions pact
5092: where pact.payroll_action_id = pactid
5093: and prl.payroll_id = pact.payroll_id
5094: and pact.effective_date between prl.effective_start_date