DBA Data[Home] [Help]

APPS.PAY_ES_RULES dependencies on PAY_INPUT_VALUES_F

Line 55: ,pay_input_values_f piv

51: CURSOR csr_get_payment_key(p_assignment_action_id NUMBER) IS
52: SELECT eev.screen_entry_value payment_key
53: FROM pay_element_entries_f pee
54: ,pay_element_entry_values_f eev
55: ,pay_input_values_f piv
56: ,pay_element_types_f pet
57: ,pay_assignment_actions paa
58: ,pay_payroll_actions ppa
59: WHERE paa.assignment_action_id = p_assignment_action_id

Line 115: ,pay_input_values_f piv

111: CURSOR csr_get_epigraph_code(p_assignment_action_id NUMBER) IS
112: SELECT eev.screen_entry_value epigraph_code
113: FROM pay_element_entries_f pee
114: ,pay_element_entry_values_f eev
115: ,pay_input_values_f piv
116: ,pay_element_types_f pet
117: ,pay_assignment_actions paa
118: ,pay_payroll_actions ppa
119: ,per_time_periods ptp

Line 159: ,pay_input_values_f piv

155: CURSOR csr_get_cac(p_assignment_action_id NUMBER) IS
156: SELECT eev.screen_entry_value sec_cac
157: FROM pay_element_entries_f pee
158: ,pay_element_entry_values_f eev
159: ,pay_input_values_f piv
160: ,pay_element_types_f pet
161: ,pay_assignment_actions paa
162: ,pay_payroll_actions ppa
163: ,per_time_periods ptp