APPS.PAY_US_RULES dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 247: from pay_element_classifications pec,

243:
244: -- Cursor to get classification of elements.
245: cursor csr_ele_classification is
246: select classification_name
247: from pay_element_classifications pec,
248: pay_element_types_f pet,
249: pay_element_entries_f pee
250: where pec.classification_id = pet.classification_id
251: and pet.element_type_id = pee.element_type_id

Line 307: l_ele_classification pay_element_classifications.classification_name%type;

303: from per_all_assignments_f paf
304: where paf.assignment_id = assign.assignment_id);
305:
306: l_asg_wrk_at_home varchar2(1);
307: l_ele_classification pay_element_classifications.classification_name%type;
308: l_proc_name varchar2(50);
309:
310: l_override_adr_region_2 per_addresses.add_information17%type;
311: l_override_adr_region_1 per_addresses.add_information17%type;