DBA Data[Home] [Help]

APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 114: FROM pay_element_entry_values_f

110: CURSOR c_get_screen_value (p_element_entryid NUMBER
111: ,p_input NUMBER )
112: IS
113: SELECT screen_entry_value
114: FROM pay_element_entry_values_f
115: WHERE element_entry_id = p_element_entryid
116: AND input_value_id = p_input;
117:
118:

Line 149: FROM pay_element_entry_values_f peev,

145: WHERE element_type_id = p_element_type_id ;
146:
147: CURSOR c_ltc_carry_over(p_element_entry_id NUMBER)
148: IS SELECT nvl(peev.screen_entry_value,'N')
149: FROM pay_element_entry_values_f peev,
150: pay_input_values_f piv
151: WHERE peev.element_entry_id = p_element_entry_id
152: AND peev.input_value_id = piv.input_value_id
153: AND piv.name ='Carryover from Prev Block';

Line 1103: FROM pay_element_entry_values_f peev,

1099:
1100: CURSOR c_get_value
1101: IS
1102: SELECT screen_entry_value
1103: FROM pay_element_entry_values_f peev,
1104: pay_element_entries_f pev,
1105: pay_element_types_f pet,
1106: pay_input_values_f piv
1107: WHERE pev.assignment_id = p_assignment_id