DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 1154: pay_element_types_f pet

1150: FROM pay_element_entry_values_f EEV,
1151: pay_element_entries_f EE,
1152: pay_link_input_values_f LIV,
1153: pay_input_values_f INPUTV,
1154: pay_element_types_f pet
1155: WHERE INPUTV.element_type_id = pet.element_type_id
1156: AND INPUTV.name = 'End of Year Bonus Percentage'
1157: AND c_effective_date BETWEEN INPUTV.effective_start_date
1158: AND INPUTV.effective_end_date

Line 1188: pay_element_types_f pet

1184: FROM pay_element_entry_values_f EEV,
1185: pay_element_entries_f EE,
1186: pay_link_input_values_f LIV,
1187: pay_input_values_f INPUTV,
1188: pay_element_types_f pet
1189: WHERE INPUTV.element_type_id = pet.element_type_id
1190: AND INPUTV.name = 'Holiday Allowance Percentage'
1191: AND c_effective_date BETWEEN INPUTV.effective_start_date
1192: AND INPUTV.effective_end_date