APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on PAY_ASSIGNMENT_ACTIONS

Line 364: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

360: ln_prev_asg_action_id NUMBER := 0;
361: ln_prev_assignment_id NUMBER := 0;
362: ld_prev_effective_date DATE ;
363: lv_report_type pay_payroll_actions.report_type%TYPE ;
364: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
365:
366:
367: lv_serial_number VARCHAR2(30);
368: ln_eoy_pactid number := 0;

Line 389: pay_assignment_actions paa,

385: ,cp_asg_set in number) is
386: select distinct paf.person_id
387: from hr_assignment_set_amendments asgset,
388: per_all_assignments_f paf,
389: pay_assignment_actions paa,
390: pay_payroll_actions ppa
391: where
392: (pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
393: ppa.legislative_parameters) = to_char(ln_pre_org_id)

Line 420: pay_assignment_actions paa,

416: ,cp_asg_set in number) is
417: select distinct paf.person_id
418: from hr_assignment_set_amendments asgset,
419: per_all_assignments_f paf,
420: pay_assignment_actions paa,
421: pay_payroll_actions ppa,
422: pay_population_ranges ppr
423: where
424: (pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

Line 462: pay_assignment_actions paa

458: report_category,
459: -- Added for bug 10399514
460: paa.assignment_action_id
461: from pay_payroll_actions ppa,
462: pay_assignment_actions paa
463: where
464: (pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
465: ppa.legislative_parameters) = to_char(cp_pre_org_id)
466: OR pay_ca_eoy_rl1_amend_arch.get_parameter('TRANSMITTER_PRE',

Line 547: select pay_assignment_actions_s.nextval

543:
544: if lv_report_type in ('RL1', 'CAEOY_RL1_AMEND_PP') then
545:
546: /* Create an assignment action for this person */
547: select pay_assignment_actions_s.nextval
548: into ln_rl1amend_asg_action
549: from dual;
550: hr_utility.trace('New RL1 Amendment Action = ' ||
551: to_char(ln_rl1amend_asg_action));

Line 553: /* Insert into pay_assignment_actions. */

549: from dual;
550: hr_utility.trace('New RL1 Amendment Action = ' ||
551: to_char(ln_rl1amend_asg_action));
552:
553: /* Insert into pay_assignment_actions. */
554: -- hr_utility.trace('creating asg. action');
555: hr_nonrun_asact.insact(ln_rl1amend_asg_action
556: ,ln_primary_assignment_id
557: ,p_payroll_action_id

Line 568: update pay_assignment_actions aa

564: table */
565:
566: -- hr_utility.trace('updating asg. action');
567:
568: update pay_assignment_actions aa
569: set aa.serial_number = to_char(p_person_id)
570: where aa.assignment_action_id = ln_rl1amend_asg_action;
571:
572: /* Interlock the YEPP or Previous RL1 Amendment Archiver