APPS.PAY_CA_RL1_AMEND_MAG dependencies on PAY_CA_EOY_RL1_AMEND_REG

Line 523: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

519: ,cp_business_group_id in number) is
520: select ppa.report_type,
521: paa.assignment_id,
522: paa.assignment_action_id,
523: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
524: ppa.legislative_parameters)
525: from pay_payroll_actions ppa,
526: pay_assignment_actions paa,
527: per_assignments_f paf

Line 530: /* and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

526: pay_assignment_actions paa,
527: per_assignments_f paf
528: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
529: and paa.assignment_id = paf.assignment_id
530: /* and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
531: ppa.legislative_parameters) =
532: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
533: ppa.legislative_parameters))*/
534: and paa.action_status = 'C'

Line 532: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

528: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
529: and paa.assignment_id = paf.assignment_id
530: /* and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
531: ppa.legislative_parameters) =
532: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
533: ppa.legislative_parameters))*/
534: and paa.action_status = 'C'
535: and ppa.payroll_action_id = paa.payroll_action_id
536: and ppa.effective_date = cp_effective_date

Line 556: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

552: AND passt.serial_number=to_char(cp_person_id)
553: AND (pail.locked_action_id = paa.assignment_action_id
554: OR paa.assignment_action_id < passt.assignment_action_id))
555: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
556: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
557: ppa.legislative_parameters) --Bug 9133270
558: order by paa.assignment_action_id desc;
559: -- added again Order by clause for bug 10648144
560:

Line 596: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

592: and report_qualifier = 'CAEOYRL1'
593: and action_type = 'X'
594: and action_status = 'C'
595: and effective_date = cp_year
596: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
597: legislative_parameters)
598: = to_char(cp_pre);
599:
600: CURSOR c_paa_update_check (cp_locking_asg_act_id number) IS