APPS.PAY_CA_RL2_AMEND_MAG dependencies on PAY_CA_EOY_RL1_AMEND_REG

Line 439: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

435: ,cp_business_group_id in number) is
436: select ppa.report_type,
437: paa.assignment_id,
438: paa.assignment_action_id,
439: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
440: ppa.legislative_parameters)
441: from pay_payroll_actions ppa,
442: pay_assignment_actions paa
443: where paa.serial_number = to_char(cp_person_id)

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

440: ppa.legislative_parameters)
441: from pay_payroll_actions ppa,
442: pay_assignment_actions paa
443: where paa.serial_number = to_char(cp_person_id)
444: /* and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
445: ppa.legislative_parameters) =
446: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
447: ppa.legislative_parameters))*/
448: and paa.action_status = 'C'

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

442: pay_assignment_actions paa
443: where paa.serial_number = to_char(cp_person_id)
444: /* and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
445: ppa.legislative_parameters) =
446: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
447: ppa.legislative_parameters))*/
448: and paa.action_status = 'C'
449: and ppa.payroll_action_id = paa.payroll_action_id
450: and ppa.effective_date = cp_effective_date

Line 471: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

467: AND (pail.locked_action_id = paa.assignment_action_id
468: OR paa.assignment_action_id < passt.assignment_action_id))
469: -- order by paa.assignment_action_id desc;
470: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
471: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
472: ppa.legislative_parameters) --Bug 9133270
473: order by paa.assignment_action_id desc;
474: -- added again Order by clause for bug 10648144
475:

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

483: and report_qualifier = 'CAEOYRL2'
484: and action_type = 'X'
485: and action_status = 'C'
486: and effective_date = cp_year
487: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
488: legislative_parameters) = to_char(cp_pre);
489:
490: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
491: select substr(full_name,1,48), employee_number