APPS.PAY_IP_PAYROLL_ARCH dependencies on PAY_INPUT_VALUES_F

Line 123: l_input_value_id pay_input_values_f.input_value_id%TYPE;

119: RETURN NUMBER
120: IS
121:
122: l_element_type_id pay_element_types_f.element_type_id%TYPE;
123: l_input_value_id pay_input_values_f.input_value_id%TYPE;
124: lv_procedure_name VARCHAR2(50);
125: lv_error_message VARCHAR2(200);
126:
127: l_result NUMBER := NULL;

Line 138: FROM pay_input_values_f pivf

134: IS
135: SELECT pivf.input_value_id
136: ,pivf.name
137: ,decode(pivf.name,'Hours',1,2) sort_index
138: FROM pay_input_values_f pivf
139: WHERE pivf.element_type_id = c_element_type_id
140: AND substr(pivf.uom,1,1) = 'H'
141: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date
142: ORDER BY sort_index;

Line 1761: ,pay_input_values_f piv

1757: FROM pay_payroll_actions ppa
1758: ,pay_assignment_actions paa
1759: ,pay_run_results prr
1760: ,pay_run_result_values prrv
1761: ,pay_input_values_f piv
1762: ,pay_element_types_f pet
1763: ,pay_element_types_f_tl petl
1764: ,pay_element_classifications pec
1765: ,per_assignments_f paf

Line 1847: ,pay_input_values_f piv

1843: FROM pay_payroll_actions ppa
1844: ,pay_assignment_actions paa
1845: ,pay_run_results prr
1846: ,pay_run_result_values prrv
1847: ,pay_input_values_f piv
1848: ,pay_element_types_f pet
1849: ,pay_element_types_f_tl petl
1850: ,pay_element_classifications pec
1851: ,pay_action_interlocks pai

Line 3375: ,pay_input_values_f piv

3371: ,pay_run_results prr
3372: ,pay_run_result_values prrv
3373: ,per_time_periods ptp
3374: ,pay_element_types_f pet
3375: ,pay_input_values_f piv
3376: ,pay_element_entries_f pee
3377: ,per_absence_attendance_types pat
3378: ,per_absence_attendances pab
3379: WHERE paa.assignment_action_id = p_assg_act_id