APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_PAYROLL_ACTIONS

Line 1024: FROM pay_payroll_actions

1020: -- Get
1021:
1022: CURSOR csr_get_effective_date(l_payroll_action_id in Number) IS
1023: SELECT effective_date
1024: FROM pay_payroll_actions
1025: WHERE payroll_action_id = l_payroll_action_id;
1026:
1027: begin
1028: l_check_age := 'N';

Line 1056: FROM pay_payroll_actions

1052: -- Get
1053:
1054: CURSOR csr_get_effective_date(l_payroll_action_id in Number) IS
1055: SELECT effective_date
1056: FROM pay_payroll_actions
1057: WHERE payroll_action_id = l_payroll_action_id;
1058:
1059: begin
1060: l_check_age := 'N';

Line 1090: from pay_payroll_actions

1086: l_check_years varchar2(1);
1087:
1088: cursor csr_get_current_date is
1089: select effective_date
1090: from pay_payroll_actions
1091: where payroll_action_id = p_payroll_action_id;
1092:
1093: cursor csr_get_ele_entry_info is
1094: select creator_type, source_id, source_asg_action_id

Line 1102: pay_payroll_actions ppa

1098: cursor csr_get_orig_date_rr(l_run_result_id in number) is
1099: select ppa.effective_date
1100: from pay_run_results prr,
1101: pay_assignment_actions paa,
1102: pay_payroll_actions ppa
1103: where prr.run_result_id = l_run_result_id
1104: and prr.assignment_action_id = paa.assignment_action_id
1105: and paa.payroll_action_id = ppa.payroll_action_id;
1106:

Line 1110: pay_payroll_actions ppa

1106:
1107: cursor csr_get_orig_date_asgact(l_asg_action_id in number) is
1108: select ppa.effective_date
1109: from pay_assignment_actions paa,
1110: pay_payroll_actions ppa
1111: where paa.assignment_action_id = l_asg_action_id
1112: and ppa.payroll_action_id = paa.payroll_action_id;
1113:
1114: begin