APPS.PAY_BAL_ADJUST dependencies on PAY_PAYROLL_ACTIONS

Line 202: from pay_payroll_actions pac,

198: l_payroll_id,
199: l_legislation_code,
200: l_mode,
201: l_action_type
202: from pay_payroll_actions pac,
203: per_business_groups pbg
204: where pac.payroll_action_id = p_batch_id
205: and pac.action_status <> 'C'
206: and pbg.business_group_id = pac.business_group_id;

Line 339: pay_payroll_actions_s.nextval

335: -- Get the business group from consolidation set
336: -- and validate at same time.
337: -- Also check that payroll_id passed in is valid.
338: select con.business_group_id,
339: pay_payroll_actions_s.nextval
340: into l_business_group_id,
341: l_payroll_action_id
342: from pay_consolidation_sets con,
343: pay_all_payrolls_f prl

Line 357: insert into pay_payroll_actions (

353: fetch csr_time_period into l_time_period_id;
354: close csr_time_period;
355:
356: -- We can now insert the payroll action.
357: insert into pay_payroll_actions (
358: payroll_action_id,
359: action_type,
360: business_group_id,
361: consolidation_set_id,

Line 383: pay_payroll_actions_s.nextval,

379: 'P',
380: 'U',
381: p_effective_date,
382: p_effective_date,
383: pay_payroll_actions_s.nextval,
384: p_batch_name,
385: p_prepay_flag,
386: p_batch_mode,
387: 1,

Line 1244: update pay_payroll_actions pac

1240: ptp.start_date and ptp.end_date;
1241:
1242: -- Stamp payroll action with the time_period_id and
1243: -- payroll_id whilst setting the statuses to success.
1244: update pay_payroll_actions pac
1245: set pac.action_status = 'C',
1246: pac.action_population_status = 'C',
1247: pac.time_period_id = l_timperid
1248: where pac.payroll_action_id = p_batch_id;