DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 509: FROM pay_input_values_f piv,

505: CURSOR csr_input_value_id(p_element_name CHAR,
506: p_value_name CHAR) IS
507: SELECT pet.element_type_id,
508: piv.input_value_id
509: FROM pay_input_values_f piv,
510: pay_element_types_f pet
511: WHERE piv.element_type_id = pet.element_type_id
512: AND pet.legislation_code = 'IE'
513: AND pet.element_name = p_element_name

Line 1289: , pay_input_values_f PROCESS_IV

1285: , per_time_periods PPTP
1286: , per_time_periods BPTP
1287: , pay_run_results PROCESS_RR
1288: , pay_run_result_values PROCESS
1289: , pay_input_values_f PROCESS_IV
1290: , pay_action_contexts ACX_PROCESS_ID
1291: , ff_contexts CON_PROCESS_ID
1292: where BAL_ASSACT.assignment_action_id = p_source_id
1293: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 2230: pay_input_values_f piv,

2226: cursor cur_non_cum_tax is
2227: select result_value
2228: from pay_run_result_values prr,
2229: pay_run_results pr,
2230: pay_input_values_f piv,
2231: pay_assignment_actions pas,
2232: pay_payroll_actions ppa
2233: where pas.assignment_id in (select assignment_id
2234: from per_all_assignments_f

Line 2520: FROM pay_input_values_f piv,

2516: CURSOR csr_input_value_id(p_element_name CHAR,
2517: p_value_name CHAR) IS
2518: SELECT pet.element_type_id,
2519: piv.input_value_id
2520: FROM pay_input_values_f piv,
2521: pay_element_types_f pet
2522: WHERE piv.element_type_id = pet.element_type_id
2523: AND pet.legislation_code = 'IE'
2524: AND pet.element_name = p_element_name