DBA Data[Home] [Help]

APPS.PAY_GB_RETRO_UPGRADE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 156: from pay_element_types_f pet, pay_element_classifications pec

152: ,p_qualified out nocopy varchar2)
153: IS
154: cursor c_element_class(cp_element_type_id in number) is
155: select pet.classification_id, pet.element_name, pet.legislation_code, pet.business_group_id, pec.classification_name
156: from pay_element_types_f pet, pay_element_classifications pec
157: where pet.element_type_id = cp_element_type_id
158: and pet.classification_id = pec.classification_id;
159:
160: cursor c_legislation_code(cp_business_group_id in number) is

Line 208: lv_classification_name pay_element_classifications.classification_name%TYPE;

204: ln_element_set_id NUMBER;
205: ln_element_used NUMBER;
206: lv_qualified VARCHAR2(1);
207: lv_element_name VARCHAR2(100);
208: lv_classification_name pay_element_classifications.classification_name%TYPE;
209: lv_procedure_name VARCHAR2(100);
210: lv_legislation_code VARCHAR2(150);
211: ln_exists VARCHAR2(1);
212: l_fi_rule_mode pay_legislative_field_info.rule_mode%TYPE;