DBA Data[Home] [Help]

APPS.PAY_FF_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 787: from pay_element_entries_f

783:
784: cursor c_get_ele_entry_dates is
785: select min(effective_start_date),
786: max(effective_end_date)
787: from pay_element_entries_f
788: where element_entry_id = p_ctx_original_entry_id
789: group by element_entry_id;
790:
791: begin

Line 914: from pay_element_entries_f

910:
911: cursor c_get_ele_entry_dates is
912: select min(effective_start_date),
913: max(effective_end_date)
914: from pay_element_entries_f
915: where element_entry_id = p_ctx_original_entry_id
916: group by element_entry_id;
917:
918: begin

Line 1086: from pay_element_entries_f pee,

1082: select pet.element_type_id, pet.element_name, pee.assignment_id,
1083: nvl(pet.element_information13,'N'),
1084: nvl(pet.element_information1, 'NONREG'),
1085: pec.classification_name
1086: from pay_element_entries_f pee,
1087: pay_element_links_f pel,
1088: pay_element_types_f pet,
1089: pay_element_classifications pec
1090: where pee.element_entry_id = cp_original_entry_id