DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_ARCHIVE_DETAIL_PKG

Line 1147: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (

1143: hr_utility.set_location('g_tax_basis_id ='||g_tax_basis_id,40);
1144: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1145: -- will have no child assignment actions. Call this only if child actions exists.
1146: IF p_payroll_child_actid IS NOT NULL THEN
1147: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (
1148: p_run_assignment_action_id => p_payroll_child_actid
1149: ,p_input_value_id => g_tax_basis_id
1150: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1151: END IF;

Line 1168: l_prsi_cat := pay_ie_archive_detail_pkg.get_tax_details (

1164: */
1165: /*
1166: IF p_supp_flag = 'Y'
1167: THEN
1168: l_prsi_cat := pay_ie_archive_detail_pkg.get_tax_details (
1169: p_run_assignment_action_id => p_payroll_child_actid
1170: ,p_input_value_id => g_prsi_cat_id
1171: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1172: -- otherise archive for all payroll runs

Line 1208: l_prsi_cur_cat := pay_ie_archive_detail_pkg.get_tax_details (

1204:
1205:
1206: FOR assg_act_rec IN cur_payroll_assg_action
1207: LOOP
1208: l_prsi_cur_cat := pay_ie_archive_detail_pkg.get_tax_details (
1209: p_run_assignment_action_id => assg_act_rec.pay_assg_act_id
1210: ,p_input_value_id => g_prsi_cat_id
1211: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1212: hr_utility.set_location('l_prsi_cur_cat = ' || l_prsi_cur_cat,40);

Line 1261: l_prsi_subcat := pay_ie_archive_detail_pkg.get_tax_details (

1257: hr_utility.set_location('g_prsi_subcat_id ='||g_prsi_subcat_id,40);
1258: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1259: -- will have no child assignment actions. Call this only if child actions exists.
1260: IF p_payroll_child_actid IS NOT NULL THEN
1261: l_prsi_subcat := pay_ie_archive_detail_pkg.get_tax_details (
1262: p_run_assignment_action_id => p_payroll_child_actid
1263: ,p_input_value_id => g_prsi_subcat_id
1264: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1265: l_ins_weeks := pay_ie_archive_detail_pkg.get_tax_details (

Line 1265: l_ins_weeks := pay_ie_archive_detail_pkg.get_tax_details (

1261: l_prsi_subcat := pay_ie_archive_detail_pkg.get_tax_details (
1262: p_run_assignment_action_id => p_payroll_child_actid
1263: ,p_input_value_id => g_prsi_subcat_id
1264: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1265: l_ins_weeks := pay_ie_archive_detail_pkg.get_tax_details (
1266: p_run_assignment_action_id => p_payroll_child_actid
1267: ,p_input_value_id => g_ins_weeks_id
1268: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1269: END IF;

Line 1307: l_weekly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (

1303: -- Tax Credit and Cutoff are now fetched from Run Results 5128377
1304: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1305: -- will have no child assignment actions. Call this only if child actions exists.
1306: IF p_payroll_child_actid IS NOT NULL THEN
1307: l_weekly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (
1308: p_run_assignment_action_id => p_payroll_child_actid
1309: ,p_input_value_id => g_week_tax_rate
1310: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1311:

Line 1313: l_period_weekly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (

1309: ,p_input_value_id => g_week_tax_rate
1310: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1311:
1312: /* 5528450 */
1313: l_period_weekly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (
1314: p_run_assignment_action_id => p_payroll_child_actid
1315: ,p_input_value_id => g_period_week_tax_rate
1316: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1317:

Line 1322: l_monthly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (

1318: IF l_period_weekly_tax_credit IS NOT NULL THEN
1319: l_weekly_tax_credit := l_period_weekly_tax_credit;
1320: END IF;
1321:
1322: l_monthly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (
1323: p_run_assignment_action_id => p_payroll_child_actid
1324: ,p_input_value_id => g_month_tax_rate
1325: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1326:

Line 1327: l_monthly_std_rate_cutoff := pay_ie_archive_detail_pkg.get_tax_details (

1323: p_run_assignment_action_id => p_payroll_child_actid
1324: ,p_input_value_id => g_month_tax_rate
1325: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1326:
1327: l_monthly_std_rate_cutoff := pay_ie_archive_detail_pkg.get_tax_details (
1328: p_run_assignment_action_id => p_payroll_child_actid
1329: ,p_input_value_id => g_month_std_cutoff
1330: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1331:

Line 1332: l_weekly_std_rate_cutoff := pay_ie_archive_detail_pkg.get_tax_details (

1328: p_run_assignment_action_id => p_payroll_child_actid
1329: ,p_input_value_id => g_month_std_cutoff
1330: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1331:
1332: l_weekly_std_rate_cutoff := pay_ie_archive_detail_pkg.get_tax_details (
1333: p_run_assignment_action_id => p_payroll_child_actid
1334: ,p_input_value_id => g_week_std_cutoff
1335: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1336:

Line 1338: l_period_weekly_std_cutoff := pay_ie_archive_detail_pkg.get_tax_details (

1334: ,p_input_value_id => g_week_std_cutoff
1335: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1336:
1337: /* 5528450 */
1338: l_period_weekly_std_cutoff := pay_ie_archive_detail_pkg.get_tax_details (
1339: p_run_assignment_action_id => p_payroll_child_actid
1340: ,p_input_value_id => g_period_week_std_cutoff
1341: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1342:

Line 3089: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (

3085:
3086: -- Emergency Flag is now fetched from Run Results 5128377
3087: -- for bug 5386432, call only if p_child_run_ass_act_id is not null
3088: IF p_child_run_ass_act_id IS NOT NULL THEN
3089: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (
3090: p_run_assignment_action_id => p_child_run_ass_act_id
3091: ,p_input_value_id => g_tax_basis_id
3092: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
3093: END IF;