APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_PAYROLL_ACTIONS

Line 1081: FROM pay_payroll_actions

1077: -- Get
1078:
1079: CURSOR csr_get_effective_date(l_payroll_action_id in Number) IS
1080: SELECT effective_date
1081: FROM pay_payroll_actions
1082: WHERE payroll_action_id = l_payroll_action_id;
1083:
1084: begin
1085: l_check_age := 'N';

Line 1174: pay_payroll_actions ppa,

1170: from pay_element_types_f pet,
1171: pay_input_values_f piv,
1172: pay_element_entries_f pee,
1173: pay_element_entry_Values_f pev,
1174: pay_payroll_actions ppa,
1175: pay_assignment_actions paa,
1176: pay_payroll_actions ppa2
1177: where pee.assignment_id = l_assignment_id
1178: and piv.element_type_id = pet.element_type_id

Line 1176: pay_payroll_actions ppa2

1172: pay_element_entries_f pee,
1173: pay_element_entry_Values_f pev,
1174: pay_payroll_actions ppa,
1175: pay_assignment_actions paa,
1176: pay_payroll_actions ppa2
1177: where pee.assignment_id = l_assignment_id
1178: and piv.element_type_id = pet.element_type_id
1179: and pee.element_type_id = pet.element_type_id
1180: and pee.element_entry_id = pev.element_Entry_id

Line 1193: from pay_payroll_actions

1189: and to_char(ppa.effective_date,'YYYY') = to_char(ppa2.effective_date,'YYYY');
1190:
1191: CURSOR csr_get_effective_year( l_payroll_action_id in Number ) IS
1192: select to_number(to_char(effective_date,'YYYY'))
1193: from pay_payroll_actions
1194: where payroll_action_id = l_payroll_action_id;
1195:
1196: begin
1197: l_value := 0;

Line 1228: FROM pay_payroll_actions

1224: -- Get
1225:
1226: CURSOR csr_get_effective_date(l_payroll_action_id in Number) IS
1227: SELECT effective_date
1228: FROM pay_payroll_actions
1229: WHERE payroll_action_id = l_payroll_action_id;
1230:
1231: begin
1232: l_check_age := 'N';

Line 1266: from pay_payroll_actions

1262: l_check_location varchar2(1);
1263:
1264: cursor csr_get_current_date is
1265: select effective_date
1266: from pay_payroll_actions
1267: where payroll_action_id = p_payroll_action_id;
1268:
1269: cursor csr_get_ele_entry_info is
1270: select creator_type, source_id, source_asg_action_id,assignment_id

Line 1286: pay_payroll_actions ppa,

1282: cursor csr_get_orig_date_rr(l_run_result_id in number) is
1283: select ppa.effective_date,hla.region_1
1284: from pay_run_results prr,
1285: pay_assignment_actions paa,
1286: pay_payroll_actions ppa,
1287: per_all_assignments_f paf,
1288: hr_locations_all hla
1289: where prr.run_result_id = l_run_result_id
1290: and prr.assignment_action_id = paa.assignment_action_id

Line 1299: pay_payroll_actions ppa,

1295:
1296: cursor csr_get_orig_date_asgact(l_asg_action_id in number) is
1297: select ppa.effective_date,hla.region_1
1298: from pay_assignment_actions paa,
1299: pay_payroll_actions ppa,
1300: per_all_assignments_f paf,
1301: hr_locations_all hla
1302: where paa.assignment_action_id = l_asg_action_id
1303: and ppa.payroll_action_id = paa.payroll_action_id