APPS.PAY_US_RULES dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 192: from pay_element_classifications pec,

188:
189: -- Cursor to get classification of elements.
190: cursor csr_ele_classification is
191: select classification_name
192: from pay_element_classifications pec,
193: pay_element_types_f pet,
194: pay_element_entries_f pee
195: where pec.classification_id = pet.classification_id
196: and pet.element_type_id = pee.element_type_id

Line 252: l_ele_classification pay_element_classifications.classification_name%type;

248: from per_all_assignments_f paf
249: where paf.assignment_id = assign.assignment_id);
250:
251: l_asg_wrk_at_home varchar2(1);
252: l_ele_classification pay_element_classifications.classification_name%type;
253: l_proc_name varchar2(50);
254:
255: l_override_adr_region_2 per_addresses.add_information17%type;
256: l_override_adr_region_1 per_addresses.add_information17%type;