APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1173: l_classification_name pay_element_classifications.classification_name%type;

1169: is
1170: --
1171: l_proc_type varchar2(30);
1172: --
1173: l_classification_name pay_element_classifications.classification_name%type;
1174: --
1175: cursor csr_classification
1176: is
1177: select /*+ ORDERED */

Line 1183: pay_element_classifications pec

1179: from pay_assignment_actions paa,
1180: pay_payroll_actions ppa,
1181: pay_run_results prr,
1182: pay_element_types_f pet,
1183: pay_element_classifications pec
1184: where paa.assignment_action_id = p_assignment_action_id
1185: and ppa.payroll_action_id = paa.payroll_action_id
1186: and prr.assignment_action_id = paa.assignment_action_id
1187: and pet.element_type_id = prr.element_type_id