APPS.PAY_CA_EOY_RL2_AMEND_ARCH dependencies on PAY_ASSIGNMENT_ACTIONS

Line 356: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

352: ln_prev_asg_action_id NUMBER := 0;
353: ln_prev_assignment_id NUMBER := 0;
354: ld_prev_effective_date DATE ;
355: lv_report_type pay_payroll_actions.report_type%TYPE ;
356: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
357:
358:
359: lv_serial_number VARCHAR2(30);
360: ln_eoy_pactid number := 0;

Line 380: pay_assignment_actions paa,

376: ,cp_asg_set in number) is
377: select distinct paf.person_id
378: from hr_assignment_set_amendments asgset,
379: per_all_assignments_f paf,
380: pay_assignment_actions paa,
381: pay_payroll_actions ppa
382: where
383: (pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
384: ppa.legislative_parameters) = to_char(ln_pre_org_id)

Line 409: pay_assignment_actions paa,

405: ,cp_asg_set in number) is
406: select distinct paf.person_id
407: from hr_assignment_set_amendments asgset,
408: per_all_assignments_f paf,
409: pay_assignment_actions paa,
410: pay_payroll_actions ppa,
411: pay_population_ranges ppr
412: where
413: (pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

Line 447: pay_assignment_actions paa

443: report_category,
444: -- Added for bug 10399514
445: paa.assignment_action_id
446: from pay_payroll_actions ppa,
447: pay_assignment_actions paa
448: where (pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
449: ppa.legislative_parameters) = to_char(ln_pre_org_id)
450: OR pay_ca_eoy_rl2_amend_arch.get_parameter('TRANSMITTER_PRE',
451: ppa.legislative_parameters) = to_char(ln_pre_org_id))

Line 531: select pay_assignment_actions_s.nextval

527:
528: if lv_report_type in ('RL2', 'CAEOY_RL2_AMEND_PP') then
529:
530: /* Create an assignment action for this person */
531: select pay_assignment_actions_s.nextval
532: into ln_rl2amend_asg_action
533: from dual;
534: hr_utility.trace('New RL2 Amendment Action = ' ||
535: to_char(ln_rl2amend_asg_action));

Line 537: /* Insert into pay_assignment_actions. */

533: from dual;
534: hr_utility.trace('New RL2 Amendment Action = ' ||
535: to_char(ln_rl2amend_asg_action));
536:
537: /* Insert into pay_assignment_actions. */
538: -- hr_utility.trace('creating asg. action');
539: hr_nonrun_asact.insact(ln_rl2amend_asg_action
540: ,ln_primary_assignment_id
541: ,p_payroll_action_id

Line 552: update pay_assignment_actions aa

548: table */
549:
550: -- hr_utility.trace('updating asg. action');
551:
552: update pay_assignment_actions aa
553: set aa.serial_number = to_char(p_person_id)
554: where aa.assignment_action_id = ln_rl2amend_asg_action;
555:
556: /* Interlock the YEPP or Previous RL2 Amendment Archiver