DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 698: FROM pay_input_values_f piv,

694: CURSOR csr_input_value_id(p_element_name CHAR,
695: p_value_name CHAR) IS
696: SELECT pet.element_type_id,
697: piv.input_value_id
698: FROM pay_input_values_f piv,
699: pay_element_types_f pet
700: WHERE piv.element_type_id = pet.element_type_id
701: AND pet.legislation_code = 'IE'
702: AND pet.element_name = p_element_name

Line 1553: , pay_input_values_f PROCESS_IV

1549: , per_time_periods PPTP
1550: , per_time_periods BPTP
1551: , pay_run_results PROCESS_RR
1552: , pay_run_result_values PROCESS
1553: , pay_input_values_f PROCESS_IV
1554: , pay_action_contexts ACX_PROCESS_ID
1555: , ff_contexts CON_PROCESS_ID
1556: where BAL_ASSACT.assignment_action_id = p_source_id
1557: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 2897: pay_input_values_f piv,

2893: cursor cur_non_cum_tax is
2894: select result_value
2895: from pay_run_result_values prr,
2896: pay_run_results pr,
2897: pay_input_values_f piv,
2898: pay_assignment_actions pas,
2899: pay_payroll_actions ppa
2900: where pas.assignment_id in (select assignment_id
2901: from per_all_assignments_f

Line 3226: FROM pay_input_values_f piv,

3222: CURSOR csr_input_value_id(p_element_name CHAR,
3223: p_value_name CHAR) IS
3224: SELECT pet.element_type_id,
3225: piv.input_value_id
3226: FROM pay_input_values_f piv,
3227: pay_element_types_f pet
3228: WHERE piv.element_type_id = pet.element_type_id
3229: AND pet.legislation_code = 'IE'
3230: AND pet.element_name = p_element_name