DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 340: lv_class_name pay_element_classifications.classification_name%TYPE;

336: lv_frequency varchar2(100);
337: lv_ele_xtra_info PAY_ELEMENT_TYPE_EXTRA_INFO.eei_information10%TYPE;
338: ln_bg_id pay_element_types_f.business_group_id%TYPE;
339: lv_leg_code pay_element_types_f.legislation_code%TYPE;
340: lv_class_name pay_element_classifications.classification_name%TYPE;
341: lb_regular_salary boolean;
342:
343:
344: CURSOR get_RegSal_ele_entry_id(cp_leg_code IN VARCHAR2

Line 395: ,pay_element_classifications pec

391: ,pet.legislation_code
392: ,pec.classification_name
393: FROM pay_element_entries_f peef
394: ,pay_element_types_f pet
395: ,pay_element_classifications pec
396: WHERE peef.element_entry_id = cp_element_entry_id
397: and peef.assignment_id = cp_assignment_id
398: and peef.element_type_id = pet.element_type_id
399: and peef.effective_start_date >= pet.effective_start_date