DBA Data[Home] [Help]

APPS.PAY_FF_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 1109: pay_element_types_f pet,

1105: nvl(pet.element_information1, 'NONREG'),
1106: pec.classification_name
1107: from pay_element_entries_f pee,
1108: pay_element_links_f pel,
1109: pay_element_types_f pet,
1110: pay_element_classifications pec
1111: where pee.element_entry_id = cp_original_entry_id
1112: and pel.element_link_id = pee.element_link_id
1113: and pel.element_type_id = pet.element_type_id

Line 1128: ,pay_element_types_f ETYPE

1124: select ETYPE.element_type_id, ETYPE.element_name
1125: from per_all_assignments_f ASSIGN
1126: ,per_pay_bases BASES
1127: ,pay_input_values_f INPUTV
1128: ,pay_element_types_f ETYPE
1129: ,pay_rates RATE
1130: where cp_date BETWEEN ASSIGN.effective_start_date
1131: AND ASSIGN.effective_end_date
1132: and ASSIGN.assignment_id = cp_assignment_id