DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_ARCHIVE_DETAIL_PKG

Line 930: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (

926: hr_utility.set_location('g_tax_basis_id ='||g_tax_basis_id,40);
927: -- Bug 5386432, since for terminated which does not have any element attached with FPD
928: -- will have no child assignment actions. Call this only if child actions exists.
929: IF p_payroll_child_actid IS NOT NULL THEN
930: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (
931: p_run_assignment_action_id => p_payroll_child_actid
932: ,p_input_value_id => g_tax_basis_id
933: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
934: END IF;

Line 951: l_prsi_cat := pay_ie_archive_detail_pkg.get_tax_details (

947: */
948: /*
949: IF p_supp_flag = 'Y'
950: THEN
951: l_prsi_cat := pay_ie_archive_detail_pkg.get_tax_details (
952: p_run_assignment_action_id => p_payroll_child_actid
953: ,p_input_value_id => g_prsi_cat_id
954: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
955: -- otherise archive for all payroll runs

Line 991: l_prsi_cur_cat := pay_ie_archive_detail_pkg.get_tax_details (

987:
988:
989: FOR assg_act_rec IN cur_payroll_assg_action
990: LOOP
991: l_prsi_cur_cat := pay_ie_archive_detail_pkg.get_tax_details (
992: p_run_assignment_action_id => assg_act_rec.pay_assg_act_id
993: ,p_input_value_id => g_prsi_cat_id
994: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
995: hr_utility.set_location('l_prsi_cur_cat = ' || l_prsi_cur_cat,40);

Line 1042: l_prsi_subcat := pay_ie_archive_detail_pkg.get_tax_details (

1038: hr_utility.set_location('g_prsi_subcat_id ='||g_prsi_subcat_id,40);
1039: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1040: -- will have no child assignment actions. Call this only if child actions exists.
1041: IF p_payroll_child_actid IS NOT NULL THEN
1042: l_prsi_subcat := pay_ie_archive_detail_pkg.get_tax_details (
1043: p_run_assignment_action_id => p_payroll_child_actid
1044: ,p_input_value_id => g_prsi_subcat_id
1045: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1046: l_ins_weeks := pay_ie_archive_detail_pkg.get_tax_details (

Line 1046: l_ins_weeks := pay_ie_archive_detail_pkg.get_tax_details (

1042: l_prsi_subcat := pay_ie_archive_detail_pkg.get_tax_details (
1043: p_run_assignment_action_id => p_payroll_child_actid
1044: ,p_input_value_id => g_prsi_subcat_id
1045: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1046: l_ins_weeks := pay_ie_archive_detail_pkg.get_tax_details (
1047: p_run_assignment_action_id => p_payroll_child_actid
1048: ,p_input_value_id => g_ins_weeks_id
1049: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1050: END IF;

Line 1088: l_weekly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (

1084: -- Tax Credit and Cutoff are now fetched from Run Results 5128377
1085: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1086: -- will have no child assignment actions. Call this only if child actions exists.
1087: IF p_payroll_child_actid IS NOT NULL THEN
1088: l_weekly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (
1089: p_run_assignment_action_id => p_payroll_child_actid
1090: ,p_input_value_id => g_week_tax_rate
1091: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1092:

Line 1094: l_period_weekly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (

1090: ,p_input_value_id => g_week_tax_rate
1091: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1092:
1093: /* 5528450 */
1094: l_period_weekly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (
1095: p_run_assignment_action_id => p_payroll_child_actid
1096: ,p_input_value_id => g_period_week_tax_rate
1097: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1098:

Line 1103: l_monthly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (

1099: IF l_period_weekly_tax_credit IS NOT NULL THEN
1100: l_weekly_tax_credit := l_period_weekly_tax_credit;
1101: END IF;
1102:
1103: l_monthly_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (
1104: p_run_assignment_action_id => p_payroll_child_actid
1105: ,p_input_value_id => g_month_tax_rate
1106: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1107:

Line 1108: l_monthly_std_rate_cutoff := pay_ie_archive_detail_pkg.get_tax_details (

1104: p_run_assignment_action_id => p_payroll_child_actid
1105: ,p_input_value_id => g_month_tax_rate
1106: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1107:
1108: l_monthly_std_rate_cutoff := pay_ie_archive_detail_pkg.get_tax_details (
1109: p_run_assignment_action_id => p_payroll_child_actid
1110: ,p_input_value_id => g_month_std_cutoff
1111: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1112:

Line 1113: l_weekly_std_rate_cutoff := pay_ie_archive_detail_pkg.get_tax_details (

1109: p_run_assignment_action_id => p_payroll_child_actid
1110: ,p_input_value_id => g_month_std_cutoff
1111: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1112:
1113: l_weekly_std_rate_cutoff := pay_ie_archive_detail_pkg.get_tax_details (
1114: p_run_assignment_action_id => p_payroll_child_actid
1115: ,p_input_value_id => g_week_std_cutoff
1116: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1117:

Line 1119: l_period_weekly_std_cutoff := pay_ie_archive_detail_pkg.get_tax_details (

1115: ,p_input_value_id => g_week_std_cutoff
1116: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1117:
1118: /* 5528450 */
1119: l_period_weekly_std_cutoff := pay_ie_archive_detail_pkg.get_tax_details (
1120: p_run_assignment_action_id => p_payroll_child_actid
1121: ,p_input_value_id => g_period_week_std_cutoff
1122: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1123:

Line 2393: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (

2389:
2390: -- Emergency Flag is now fetched from Run Results 5128377
2391: -- for bug 5386432, call only if p_child_run_ass_act_id is not null
2392: IF p_child_run_ass_act_id IS NOT NULL THEN
2393: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (
2394: p_run_assignment_action_id => p_child_run_ass_act_id
2395: ,p_input_value_id => g_tax_basis_id
2396: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
2397: END IF;