DBA Data[Home] [Help]

APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1175: pay_assignment_actions paa,

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
1179: and pee.element_type_id = pet.element_type_id

Line 1285: pay_assignment_actions paa,

1281:
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

Line 1298: from pay_assignment_actions paa,

1294: and hla.location_id = paf.location_id;
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