DBA Data[Home] [Help]

APPS.PAY_GB_ENH_RETRO_PAY dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 135: pay_element_classifications pec

131: pet.business_group_id,
132: pec.classification_name
133: FROM
134: pay_element_types_f pet,
135: pay_element_classifications pec
136: WHERE
137: pet.element_type_id = cp_element_type_id
138: AND pet.classification_id = pec.classification_id;
139: CURSOR c_legislation_code(cp_business_group_id IN NUMBER)

Line 195: lv_classification_name pay_element_classifications.classification_name%TYPE;

191: ln_classification_id NUMBER;
192: lv_element_name VARCHAR2(100);
193: lv_legislation_code VARCHAR2(150);
194: ln_business_group_id NUMBER;
195: lv_classification_name pay_element_classifications.classification_name%TYPE;
196: lv_ele_leg_code VARCHAR2(150);
197: lv_qualified VARCHAR2(1);
198: ln_element_set_id NUMBER;
199: ln_element_used NUMBER;