DBA Data[Home] [Help]

APPS.PAY_FF_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 1088: pay_element_types_f pet,

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
1091: and pel.element_link_id = pee.element_link_id
1092: and pel.element_type_id = pet.element_type_id

Line 1107: ,pay_element_types_f ETYPE

1103: select ETYPE.element_type_id, ETYPE.element_name
1104: from per_all_assignments_f ASSIGN
1105: ,per_pay_bases BASES
1106: ,pay_input_values_f INPUTV
1107: ,pay_element_types_f ETYPE
1108: ,pay_rates RATE
1109: where cp_date BETWEEN ASSIGN.effective_start_date
1110: AND ASSIGN.effective_end_date
1111: and ASSIGN.assignment_id = cp_assignment_id