APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_CA_EOY_RL1_AMEND_ARCH

Line 1030: pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

1026:
1027: select effective_date,
1028: report_type,
1029: business_group_id,
1030: pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
1031: legislative_parameters)
1032: into l_effective_date,
1033: l_report_type,
1034: l_bus_group_id,

Line 2109: select pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

2105: WHERE aa.assignment_action_id = p_assactid;
2106:
2107: l_rl2_tax_unit_id := l_tax_unit_id;
2108:
2109: select pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
2110: legislative_parameters),
2111: business_group_id
2112: into l_pre_org_id,
2113: l_business_group_id

Line 3125: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

3121: hr_utility.trace('Started Provincial YE Amendment');
3122:
3123: select to_char(effective_date,'YYYY'),
3124: report_type,
3125: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
3126: legislative_parameters))
3127: into lv_fapp_effective_date,
3128: lv_fapp_report_type,
3129: ln_fapp_pre_org_id

Line 3222: select pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

3218: l_year_end date;
3219:
3220: begin
3221:
3222: select pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
3223: legislative_parameters),
3224: trunc(effective_date,'Y'),
3225: effective_date,
3226: business_group_id