APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 92: l_classification_name pay_element_classifications.classification_name%type;

88: is
89: --
90: l_proc_type varchar2(30);
91: --
92: l_classification_name pay_element_classifications.classification_name%type;
93: --
94: cursor csr_classification
95: is
96: select /*+ ORDERED */

Line 102: pay_element_classifications pec

98: from pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_run_results prr,
101: pay_element_types_f pet,
102: pay_element_classifications pec
103: where paa.assignment_action_id = p_assignment_action_id
104: and ppa.payroll_action_id = paa.payroll_action_id
105: and prr.assignment_action_id = paa.assignment_action_id
106: and pet.element_type_id = prr.element_type_id