DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_CA_EOY_RL1_AMEND_ARCH

Line 1141: pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

1137: report_qualifier,
1138: report_category,
1139: -- Added for bug 10399514
1140: business_group_id,
1141: pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
1142: legislative_parameters)
1143: into l_effective_date,
1144: l_report_type,
1145: -- Added for bug 10399514

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

2204: WHERE aa.assignment_action_id = p_assactid;
2205:
2206: l_rl2_tax_unit_id := l_tax_unit_id;
2207:
2208: select pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
2209: legislative_parameters),
2210: business_group_id
2211: into l_pre_org_id,
2212: l_business_group_id

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

2811: WHERE aa.assignment_action_id = p_assactid;
2812:
2813: l_rl2_tax_unit_id := l_tax_unit_id;
2814:
2815: select pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
2816: legislative_parameters),
2817: business_group_id
2818: into l_pre_org_id,
2819: l_business_group_id

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

3934: hr_utility.trace('Started Provincial YE Amendment');
3935:
3936: select to_char(effective_date,'YYYY'),
3937: report_type,
3938: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
3939: legislative_parameters))
3940: into lv_fapp_effective_date,
3941: lv_fapp_report_type,
3942: ln_fapp_pre_org_id

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

4065: l_year_end date;
4066:
4067: begin
4068:
4069: select pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
4070: legislative_parameters),
4071: trunc(effective_date,'Y'),
4072: effective_date,
4073: business_group_id