eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_P35 dependencies on PAY_ACTION_INFORMATION

Line 1167: l_arch_ppsn pay_action_information.action_information4%TYPE;

1163: l_actid NUMBER;
1164: l_locked_action NUMBER;
1165: l_out_var VARCHAR2 (30);
1166: l_effective_date DATE;
1167: l_arch_ppsn pay_action_information.action_information4%TYPE;
1168: l_arch_works_number pay_action_information.action_information14%TYPE
1169: DEFAULT ' '; --BUG 3306202 Added default value
1170: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
1171: l_arch_person_id per_assignments_f.person_id%TYPE;

Line 1168: l_arch_works_number pay_action_information.action_information14%TYPE

1164: l_locked_action NUMBER;
1165: l_out_var VARCHAR2 (30);
1166: l_effective_date DATE;
1167: l_arch_ppsn pay_action_information.action_information4%TYPE;
1168: l_arch_works_number pay_action_information.action_information14%TYPE
1169: DEFAULT ' '; --BUG 3306202 Added default value
1170: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
1171: l_arch_person_id per_assignments_f.person_id%TYPE;
1172: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;

Line 1174: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;

1170: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
1171: l_arch_person_id per_assignments_f.person_id%TYPE;
1172: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;
1173: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1174: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;
1175: l_arch_surname pay_action_information.action_information29%TYPE;
1176: l_arch_first_name pay_action_information.action_information28%TYPE;
1177: l_arch_dob pay_action_information.action_information25%TYPE;
1178: l_arch_address_line1 pay_action_information.action_information5%TYPE;

Line 1175: l_arch_surname pay_action_information.action_information29%TYPE;

1171: l_arch_person_id per_assignments_f.person_id%TYPE;
1172: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;
1173: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1174: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;
1175: l_arch_surname pay_action_information.action_information29%TYPE;
1176: l_arch_first_name pay_action_information.action_information28%TYPE;
1177: l_arch_dob pay_action_information.action_information25%TYPE;
1178: l_arch_address_line1 pay_action_information.action_information5%TYPE;
1179: l_arch_address_line2 pay_action_information.action_information6%TYPE;

Line 1176: l_arch_first_name pay_action_information.action_information28%TYPE;

1172: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;
1173: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1174: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;
1175: l_arch_surname pay_action_information.action_information29%TYPE;
1176: l_arch_first_name pay_action_information.action_information28%TYPE;
1177: l_arch_dob pay_action_information.action_information25%TYPE;
1178: l_arch_address_line1 pay_action_information.action_information5%TYPE;
1179: l_arch_address_line2 pay_action_information.action_information6%TYPE;
1180: l_arch_address_line3 pay_action_information.action_information7%TYPE; -- BUG 4066315

Line 1177: l_arch_dob pay_action_information.action_information25%TYPE;

1173: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1174: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;
1175: l_arch_surname pay_action_information.action_information29%TYPE;
1176: l_arch_first_name pay_action_information.action_information28%TYPE;
1177: l_arch_dob pay_action_information.action_information25%TYPE;
1178: l_arch_address_line1 pay_action_information.action_information5%TYPE;
1179: l_arch_address_line2 pay_action_information.action_information6%TYPE;
1180: l_arch_address_line3 pay_action_information.action_information7%TYPE; -- BUG 4066315
1181: l_arch_address_line4 pay_action_information.action_information9%TYPE; -- BUG 4066315

Line 1178: l_arch_address_line1 pay_action_information.action_information5%TYPE;

1174: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;
1175: l_arch_surname pay_action_information.action_information29%TYPE;
1176: l_arch_first_name pay_action_information.action_information28%TYPE;
1177: l_arch_dob pay_action_information.action_information25%TYPE;
1178: l_arch_address_line1 pay_action_information.action_information5%TYPE;
1179: l_arch_address_line2 pay_action_information.action_information6%TYPE;
1180: l_arch_address_line3 pay_action_information.action_information7%TYPE; -- BUG 4066315
1181: l_arch_address_line4 pay_action_information.action_information9%TYPE; -- BUG 4066315
1182: l_length_address_line2 NUMBER; -- BUG 4066315

Line 1179: l_arch_address_line2 pay_action_information.action_information6%TYPE;

1175: l_arch_surname pay_action_information.action_information29%TYPE;
1176: l_arch_first_name pay_action_information.action_information28%TYPE;
1177: l_arch_dob pay_action_information.action_information25%TYPE;
1178: l_arch_address_line1 pay_action_information.action_information5%TYPE;
1179: l_arch_address_line2 pay_action_information.action_information6%TYPE;
1180: l_arch_address_line3 pay_action_information.action_information7%TYPE; -- BUG 4066315
1181: l_arch_address_line4 pay_action_information.action_information9%TYPE; -- BUG 4066315
1182: l_length_address_line2 NUMBER; -- BUG 4066315
1183: l_available_space NUMBER; -- BUG 4066315

Line 1180: l_arch_address_line3 pay_action_information.action_information7%TYPE; -- BUG 4066315

1176: l_arch_first_name pay_action_information.action_information28%TYPE;
1177: l_arch_dob pay_action_information.action_information25%TYPE;
1178: l_arch_address_line1 pay_action_information.action_information5%TYPE;
1179: l_arch_address_line2 pay_action_information.action_information6%TYPE;
1180: l_arch_address_line3 pay_action_information.action_information7%TYPE; -- BUG 4066315
1181: l_arch_address_line4 pay_action_information.action_information9%TYPE; -- BUG 4066315
1182: l_length_address_line2 NUMBER; -- BUG 4066315
1183: l_available_space NUMBER; -- BUG 4066315
1184: l_arch_hire_date pay_action_information.action_information24%TYPE;

Line 1181: l_arch_address_line4 pay_action_information.action_information9%TYPE; -- BUG 4066315

1177: l_arch_dob pay_action_information.action_information25%TYPE;
1178: l_arch_address_line1 pay_action_information.action_information5%TYPE;
1179: l_arch_address_line2 pay_action_information.action_information6%TYPE;
1180: l_arch_address_line3 pay_action_information.action_information7%TYPE; -- BUG 4066315
1181: l_arch_address_line4 pay_action_information.action_information9%TYPE; -- BUG 4066315
1182: l_length_address_line2 NUMBER; -- BUG 4066315
1183: l_available_space NUMBER; -- BUG 4066315
1184: l_arch_hire_date pay_action_information.action_information24%TYPE;
1185: l_arch_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;

Line 1184: l_arch_hire_date pay_action_information.action_information24%TYPE;

1180: l_arch_address_line3 pay_action_information.action_information7%TYPE; -- BUG 4066315
1181: l_arch_address_line4 pay_action_information.action_information9%TYPE; -- BUG 4066315
1182: l_length_address_line2 NUMBER; -- BUG 4066315
1183: l_available_space NUMBER; -- BUG 4066315
1184: l_arch_hire_date pay_action_information.action_information24%TYPE;
1185: l_arch_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
1186: l_arch_annual_tax_credit pay_action_information.action_information26%TYPE;
1187: l_arch_term_date pay_action_information.action_information25%TYPE;
1188: l_arch_mothers_name per_people_f.per_information1%TYPE;

Line 1186: l_arch_annual_tax_credit pay_action_information.action_information26%TYPE;

1182: l_length_address_line2 NUMBER; -- BUG 4066315
1183: l_available_space NUMBER; -- BUG 4066315
1184: l_arch_hire_date pay_action_information.action_information24%TYPE;
1185: l_arch_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
1186: l_arch_annual_tax_credit pay_action_information.action_information26%TYPE;
1187: l_arch_term_date pay_action_information.action_information25%TYPE;
1188: l_arch_mothers_name per_people_f.per_information1%TYPE;
1189: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1190: l_arch_initial_class pay_run_result_values.result_value%TYPE;

Line 1187: l_arch_term_date pay_action_information.action_information25%TYPE;

1183: l_available_space NUMBER; -- BUG 4066315
1184: l_arch_hire_date pay_action_information.action_information24%TYPE;
1185: l_arch_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
1186: l_arch_annual_tax_credit pay_action_information.action_information26%TYPE;
1187: l_arch_term_date pay_action_information.action_information25%TYPE;
1188: l_arch_mothers_name per_people_f.per_information1%TYPE;
1189: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1190: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1191: l_arch_second_class pay_run_result_values.result_value%TYPE;

Line 1200: l_arch_net_tax pay_action_information.action_information4%TYPE;

1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1200: l_arch_net_tax pay_action_information.action_information4%TYPE;
1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;
1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;
1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;

Line 1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;

1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1200: l_arch_net_tax pay_action_information.action_information4%TYPE;
1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;
1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;
1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;
1205: l_arch_pay pay_action_information.action_information4%TYPE;

Line 1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;

1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1200: l_arch_net_tax pay_action_information.action_information4%TYPE;
1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;
1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;
1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;
1205: l_arch_pay pay_action_information.action_information4%TYPE;
1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502

Line 1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;

1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1200: l_arch_net_tax pay_action_information.action_information4%TYPE;
1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;
1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;
1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;
1205: l_arch_pay pay_action_information.action_information4%TYPE;
1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502
1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;

Line 1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;

1200: l_arch_net_tax pay_action_information.action_information4%TYPE;
1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;
1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;
1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;
1205: l_arch_pay pay_action_information.action_information4%TYPE;
1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502
1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;
1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;

Line 1205: l_arch_pay pay_action_information.action_information4%TYPE;

1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;
1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;
1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;
1205: l_arch_pay pay_action_information.action_information4%TYPE;
1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502
1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;
1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;
1209: l_arch_ovn pay_action_information.object_version_number%TYPE;

Line 1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502

1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;
1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;
1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;
1205: l_arch_pay pay_action_information.action_information4%TYPE;
1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502
1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;
1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;
1209: l_arch_ovn pay_action_information.object_version_number%TYPE;
1210: l_arch_previous_emp_pay pay_action_information.action_information28%TYPE;

Line 1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;

1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;
1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;
1205: l_arch_pay pay_action_information.action_information4%TYPE;
1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502
1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;
1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;
1209: l_arch_ovn pay_action_information.object_version_number%TYPE;
1210: l_arch_previous_emp_pay pay_action_information.action_information28%TYPE;
1211: l_arch_previous_emp_tax pay_action_information.action_information29%TYPE;

Line 1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;

1204: l_arch_employer_prsi_cont pay_action_information.action_information4%TYPE;
1205: l_arch_pay pay_action_information.action_information4%TYPE;
1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502
1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;
1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;
1209: l_arch_ovn pay_action_information.object_version_number%TYPE;
1210: l_arch_previous_emp_pay pay_action_information.action_information28%TYPE;
1211: l_arch_previous_emp_tax pay_action_information.action_information29%TYPE;
1212: l_arch_pr_indicator pay_action_information.action_information30%TYPE;

Line 1209: l_arch_ovn pay_action_information.object_version_number%TYPE;

1205: l_arch_pay pay_action_information.action_information4%TYPE;
1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502
1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;
1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;
1209: l_arch_ovn pay_action_information.object_version_number%TYPE;
1210: l_arch_previous_emp_pay pay_action_information.action_information28%TYPE;
1211: l_arch_previous_emp_tax pay_action_information.action_information29%TYPE;
1212: l_arch_pr_indicator pay_action_information.action_information30%TYPE;
1213: l_arch_action_info_id NUMBER;

Line 1210: l_arch_previous_emp_pay pay_action_information.action_information28%TYPE;

1206: l_arch_non_tax_pay pay_action_information.action_information4%TYPE; --Bug 4063502
1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;
1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;
1209: l_arch_ovn pay_action_information.object_version_number%TYPE;
1210: l_arch_previous_emp_pay pay_action_information.action_information28%TYPE;
1211: l_arch_previous_emp_tax pay_action_information.action_information29%TYPE;
1212: l_arch_pr_indicator pay_action_information.action_information30%TYPE;
1213: l_arch_action_info_id NUMBER;
1214: l_arch_total_notional_pay pay_action_information.action_information4%TYPE;

Line 1211: l_arch_previous_emp_tax pay_action_information.action_information29%TYPE;

1207: l_arch_prev_pay pay_action_information.action_information4%TYPE;
1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;
1209: l_arch_ovn pay_action_information.object_version_number%TYPE;
1210: l_arch_previous_emp_pay pay_action_information.action_information28%TYPE;
1211: l_arch_previous_emp_tax pay_action_information.action_information29%TYPE;
1212: l_arch_pr_indicator pay_action_information.action_information30%TYPE;
1213: l_arch_action_info_id NUMBER;
1214: l_arch_total_notional_pay pay_action_information.action_information4%TYPE;
1215: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171

Line 1212: l_arch_pr_indicator pay_action_information.action_information30%TYPE;

1208: l_arch_prev_tax pay_action_information.action_information4%TYPE;
1209: l_arch_ovn pay_action_information.object_version_number%TYPE;
1210: l_arch_previous_emp_pay pay_action_information.action_information28%TYPE;
1211: l_arch_previous_emp_tax pay_action_information.action_information29%TYPE;
1212: l_arch_pr_indicator pay_action_information.action_information30%TYPE;
1213: l_arch_action_info_id NUMBER;
1214: l_arch_total_notional_pay pay_action_information.action_information4%TYPE;
1215: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171
1216: -- Temporary variable to hold values when Class K or M exists

Line 1214: l_arch_total_notional_pay pay_action_information.action_information4%TYPE;

1210: l_arch_previous_emp_pay pay_action_information.action_information28%TYPE;
1211: l_arch_previous_emp_tax pay_action_information.action_information29%TYPE;
1212: l_arch_pr_indicator pay_action_information.action_information30%TYPE;
1213: l_arch_action_info_id NUMBER;
1214: l_arch_total_notional_pay pay_action_information.action_information4%TYPE;
1215: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171
1216: -- Temporary variable to hold values when Class K or M exists
1217: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1218: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;

Line 1217: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;

1213: l_arch_action_info_id NUMBER;
1214: l_arch_total_notional_pay pay_action_information.action_information4%TYPE;
1215: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171
1216: -- Temporary variable to hold values when Class K or M exists
1217: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1218: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1219: l_pds_id per_periods_of_service.period_of_service_id%TYPE;
1220: l_asg_id per_assignments_f.assignment_id%TYPE;
1221: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1218: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;

1214: l_arch_total_notional_pay pay_action_information.action_information4%TYPE;
1215: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171
1216: -- Temporary variable to hold values when Class K or M exists
1217: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1218: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1219: l_pds_id per_periods_of_service.period_of_service_id%TYPE;
1220: l_asg_id per_assignments_f.assignment_id%TYPE;
1221: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1222: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;

Line 1227: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;

1223: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1224: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1225: v_primary_flag per_assignments_f.primary_flag%TYPE;
1226: -- pension variables
1227: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;
1228: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;
1229: l_arch_pen_emp_prsa pay_action_information.action_information30%TYPE;
1230: l_arch_pen_empr_prsa pay_action_information.action_information30%TYPE;
1231: l_arch_pen_emp_rac pay_action_information.action_information30%TYPE;

Line 1228: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;

1224: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1225: v_primary_flag per_assignments_f.primary_flag%TYPE;
1226: -- pension variables
1227: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;
1228: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;
1229: l_arch_pen_emp_prsa pay_action_information.action_information30%TYPE;
1230: l_arch_pen_empr_prsa pay_action_information.action_information30%TYPE;
1231: l_arch_pen_emp_rac pay_action_information.action_information30%TYPE;
1232: -- P60 enhancement changes. bug

Line 1229: l_arch_pen_emp_prsa pay_action_information.action_information30%TYPE;

1225: v_primary_flag per_assignments_f.primary_flag%TYPE;
1226: -- pension variables
1227: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;
1228: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;
1229: l_arch_pen_emp_prsa pay_action_information.action_information30%TYPE;
1230: l_arch_pen_empr_prsa pay_action_information.action_information30%TYPE;
1231: l_arch_pen_emp_rac pay_action_information.action_information30%TYPE;
1232: -- P60 enhancement changes. bug
1233:

Line 1230: l_arch_pen_empr_prsa pay_action_information.action_information30%TYPE;

1226: -- pension variables
1227: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;
1228: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;
1229: l_arch_pen_emp_prsa pay_action_information.action_information30%TYPE;
1230: l_arch_pen_empr_prsa pay_action_information.action_information30%TYPE;
1231: l_arch_pen_emp_rac pay_action_information.action_information30%TYPE;
1232: -- P60 enhancement changes. bug
1233:
1234: -- bik medical insurance 5867343

Line 1231: l_arch_pen_emp_rac pay_action_information.action_information30%TYPE;

1227: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;
1228: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;
1229: l_arch_pen_emp_prsa pay_action_information.action_information30%TYPE;
1230: l_arch_pen_empr_prsa pay_action_information.action_information30%TYPE;
1231: l_arch_pen_emp_rac pay_action_information.action_information30%TYPE;
1232: -- P60 enhancement changes. bug
1233:
1234: -- bik medical insurance 5867343
1235: l_medical_insurance pay_action_information.action_information30%TYPE;

Line 1235: l_medical_insurance pay_action_information.action_information30%TYPE;

1231: l_arch_pen_emp_rac pay_action_information.action_information30%TYPE;
1232: -- P60 enhancement changes. bug
1233:
1234: -- bik medical insurance 5867343
1235: l_medical_insurance pay_action_information.action_information30%TYPE;
1236: --6633719
1237: l_dimension_name VARCHAR2(100):= '_PER_PAYE_REF_YTD';
1238:
1239: CURSOR get_actid_from_interlocks IS

Line 1260: and exists (select 1 from pay_action_information pai

1256: AND paa.action_status = 'C'
1257: AND (ppa.action_type IN ('P', 'U')
1258: OR (ppa.action_type='X' and ppa.report_type = 'IEPS'
1259: and paa.source_action_id IS NULL
1260: and exists (select 1 from pay_action_information pai
1261: where pai.action_information_category = 'IE EMPLOYEE DETAILS'
1262: AND pai.action_context_type='AAP'
1263: AND pai.action_context_id=paa.assignment_action_id)))
1264: ORDER BY paa.assignment_action_id DESC;

Line 1283: pay_action_information pai

1279: SELECT paa.assignment_action_id
1280: FROM pay_action_interlocks pal,
1281: pay_assignment_actions paa,
1282: pay_payroll_actions ppa,
1283: pay_action_information pai
1284: WHERE pal.locked_action_id = p_asg_act_id
1285: AND pal.locking_action_id = paa.assignment_action_id
1286: AND paa.source_action_id IS NULL
1287: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1317: FROM pay_action_information pai1,

1313: CURSOR csr_p30_bal_value (p_locked_action_id NUMBER,
1314: p_balance_name VARCHAR2, --6633719
1315: p_dimension_name VARCHAR2) IS --6633719
1316: SELECT SUBSTR (pai1.action_information4, 1, 30) bval
1317: FROM pay_action_information pai1,
1318: pay_balance_types pbt,
1319: pay_balance_dimensions pbd,
1320: pay_defined_balances pdb
1321: WHERE pdb.balance_type_id = pbt.balance_type_id

Line 1336: FROM pay_action_information pai

1332: --6633719
1333: CURSOR csr_rehire_ppsn_arch(p_locked_action_id NUMBER)
1334: IS
1335: SELECT NVL(action_information20,'N') PPSN_BAL_ARCHIVED
1336: FROM pay_action_information pai
1337: WHERE
1338: pai.action_context_type = 'AAP'
1339: AND pai.action_information_category = 'IE EMPLOYEE DETAILS'
1340: AND pai.action_context_id = p_locked_action_id;

Line 1426: FROM pay_action_information pact_edi,

1422: 2
1423: ),
1424: 0
1425: ) -- Q1_Previous_Emp_Tax
1426: FROM pay_action_information pact_edi,
1427: pay_action_information pact_iedi,
1428: pay_action_information pact_ad,
1429: per_assignments_f paf,
1430: per_periods_of_service pps,

Line 1427: pay_action_information pact_iedi,

1423: ),
1424: 0
1425: ) -- Q1_Previous_Emp_Tax
1426: FROM pay_action_information pact_edi,
1427: pay_action_information pact_iedi,
1428: pay_action_information pact_ad,
1429: per_assignments_f paf,
1430: per_periods_of_service pps,
1431: -- pay_ie_paye_details_f payef,

Line 1428: pay_action_information pact_ad,

1424: 0
1425: ) -- Q1_Previous_Emp_Tax
1426: FROM pay_action_information pact_edi,
1427: pay_action_information pact_iedi,
1428: pay_action_information pact_ad,
1429: per_assignments_f paf,
1430: per_periods_of_service pps,
1431: -- pay_ie_paye_details_f payef,
1432: per_time_periods ptp,

Line 2099: l_prev_pay pay_action_information.action_information4%TYPE;

2095: asg_assignment_id per_assignments_f.assignment_id%TYPE;
2096: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;
2097: l_cnt number;
2098: -- for P60 enhancement.
2099: l_prev_pay pay_action_information.action_information4%TYPE;
2100: l_this_pay pay_action_information.action_information4%TYPE;
2101: l_prev_tax pay_action_information.action_information4%TYPE;
2102: l_this_tax pay_action_information.action_information4%TYPE;
2103: l_temp_pay pay_action_information.action_information4%TYPE;

Line 2100: l_this_pay pay_action_information.action_information4%TYPE;

2096: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;
2097: l_cnt number;
2098: -- for P60 enhancement.
2099: l_prev_pay pay_action_information.action_information4%TYPE;
2100: l_this_pay pay_action_information.action_information4%TYPE;
2101: l_prev_tax pay_action_information.action_information4%TYPE;
2102: l_this_tax pay_action_information.action_information4%TYPE;
2103: l_temp_pay pay_action_information.action_information4%TYPE;
2104: l_temp_tax pay_action_information.action_information4%TYPE;

Line 2101: l_prev_tax pay_action_information.action_information4%TYPE;

2097: l_cnt number;
2098: -- for P60 enhancement.
2099: l_prev_pay pay_action_information.action_information4%TYPE;
2100: l_this_pay pay_action_information.action_information4%TYPE;
2101: l_prev_tax pay_action_information.action_information4%TYPE;
2102: l_this_tax pay_action_information.action_information4%TYPE;
2103: l_temp_pay pay_action_information.action_information4%TYPE;
2104: l_temp_tax pay_action_information.action_information4%TYPE;
2105:

Line 2102: l_this_tax pay_action_information.action_information4%TYPE;

2098: -- for P60 enhancement.
2099: l_prev_pay pay_action_information.action_information4%TYPE;
2100: l_this_pay pay_action_information.action_information4%TYPE;
2101: l_prev_tax pay_action_information.action_information4%TYPE;
2102: l_this_tax pay_action_information.action_information4%TYPE;
2103: l_temp_pay pay_action_information.action_information4%TYPE;
2104: l_temp_tax pay_action_information.action_information4%TYPE;
2105:
2106: -- end P60

Line 2103: l_temp_pay pay_action_information.action_information4%TYPE;

2099: l_prev_pay pay_action_information.action_information4%TYPE;
2100: l_this_pay pay_action_information.action_information4%TYPE;
2101: l_prev_tax pay_action_information.action_information4%TYPE;
2102: l_this_tax pay_action_information.action_information4%TYPE;
2103: l_temp_pay pay_action_information.action_information4%TYPE;
2104: l_temp_tax pay_action_information.action_information4%TYPE;
2105:
2106: -- end P60
2107: -- For P60 changes to PRSI section

Line 2104: l_temp_tax pay_action_information.action_information4%TYPE;

2100: l_this_pay pay_action_information.action_information4%TYPE;
2101: l_prev_tax pay_action_information.action_information4%TYPE;
2102: l_this_tax pay_action_information.action_information4%TYPE;
2103: l_temp_pay pay_action_information.action_information4%TYPE;
2104: l_temp_tax pay_action_information.action_information4%TYPE;
2105:
2106: -- end P60
2107: -- For P60 changes to PRSI section
2108: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;

Line 4456: pay_action_information_api.create_action_information (

4452: hr_utility.set_location('l_ppsn_override..'||l_ppsn_override,1009);
4453: hr_utility.set_location('l_arch_ppsn..'||l_arch_ppsn,1009);
4454: hr_utility.set_location('l_max_assignment_id..'||l_max_assignment_id,1009);
4455:
4456: pay_action_information_api.create_action_information (
4457: p_action_context_id=> p_assactid,
4458: p_action_context_type=> 'AAP',
4459: p_action_information_category=> 'IE P35 DETAIL',
4460: p_assignment_id => l_max_assignment_id,

Line 4498: pay_action_information_api.create_action_information (

4494: p_object_version_number=> l_arch_ovn);
4495:
4496: hr_utility.set_location('Before create_action_information IE P35 ADDITIONAL DETAILS',1009);
4497:
4498: pay_action_information_api.create_action_information (
4499: p_action_context_id=> p_assactid,
4500: p_action_context_type=> 'AAP',
4501: p_action_information_category=> 'IE P35 ADDITIONAL DETAILS',
4502: p_assignment_id=> l_max_assignment_id,

Line 4551: FROM pay_action_information pai

4547: CURSOR csr_check_payroll_action IS
4548: SELECT 1
4549: FROM DUAL
4550: WHERE EXISTS (SELECT NULL
4551: FROM pay_action_information pai
4552: WHERE pai.action_context_id = p_payroll_action_id
4553: AND pai.action_context_type = 'PA'
4554: AND rownum = 1
4555: );

Line 4624: pay_action_information_api.create_action_information (

4620: l_contact_number,
4621: l_fax_number; /*Added for bug fix 3815830*/
4622: CLOSE csr_p35_header_info;
4623: -- Archive header info
4624: pay_action_information_api.create_action_information (
4625: p_action_information_id=> l_action_info_id,
4626: p_action_context_id=> p_payroll_action_id,
4627: p_action_context_type=> 'PA',
4628: p_object_version_number=> l_ovn,