DBA Data[Home] [Help]

APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 120: FROM pay_element_entry_values_f

116: CURSOR c_get_screen_value (p_element_entryid NUMBER
117: ,p_input NUMBER )
118: IS
119: SELECT screen_entry_value
120: FROM pay_element_entry_values_f
121: WHERE element_entry_id = p_element_entryid
122: AND input_value_id = p_input;
123:
124:

Line 155: FROM pay_element_entry_values_f peev,

151: WHERE element_type_id = p_element_type_id ;
152:
153: CURSOR c_ltc_carry_over(p_element_entry_id NUMBER)
154: IS SELECT nvl(peev.screen_entry_value,'N')
155: FROM pay_element_entry_values_f peev,
156: pay_input_values_f piv
157: WHERE peev.element_entry_id = p_element_entry_id
158: AND peev.input_value_id = piv.input_value_id
159: AND piv.name ='Carryover from Prev Block';

Line 1152: FROM pay_element_entry_values_f peev,

1148:
1149: CURSOR c_get_value
1150: IS
1151: SELECT screen_entry_value
1152: FROM pay_element_entry_values_f peev,
1153: pay_element_entries_f pev,
1154: pay_element_types_f pet,
1155: pay_input_values_f piv
1156: WHERE pev.assignment_id = p_assignment_id