DBA Data[Home] [Help]

APPS.HR_NONRUN_ASACT dependencies on PAY_ALL_PAYROLLS_F

Line 3918: pay_all_payrolls_f pay,

3914: act.assignment_action_id,
3915: act.assignment_id,
3916: act.tax_unit_id
3917: from pay_payroll_actions pa1,
3918: pay_all_payrolls_f pay,
3919: per_time_periods ptp,
3920: pay_payroll_actions pa2,
3921: pay_action_classifications pcl,
3922: pay_population_ranges pop,

Line 3985: pay_all_payrolls_f pay,

3981: act.assignment_action_id,
3982: act.assignment_id,
3983: act.tax_unit_id
3984: from pay_payroll_actions pa1,
3985: pay_all_payrolls_f pay,
3986: per_time_periods ptp,
3987: pay_payroll_actions pa2,
3988: pay_action_classifications pcl,
3989: per_periods_of_service pos,

Line 5057: multi_asg_fg pay_all_payrolls_f.multi_assignments_flag%type;

5053: stperson number;
5054: endperson number;
5055: chunk number;
5056: rand_chunk number;
5057: multi_asg_fg pay_all_payrolls_f.multi_assignments_flag%type;
5058: l_use_pop_person number := use_pop_person;
5059: begin
5060: pay_core_utils.get_action_parameter('SET_DATE_EARNED',
5061: g_set_date_earned,

Line 5075: from pay_all_payrolls_f prl,

5071: return ;
5072: elsif (atype = PREPAY) then
5073: select nvl(multi_assignments_flag, 'N')
5074: into multi_asg_fg
5075: from pay_all_payrolls_f prl,
5076: pay_payroll_Actions pact
5077: where pact.payroll_action_id = pactid
5078: and prl.payroll_id = pact.payroll_id
5079: and pact.effective_date between prl.effective_start_date