APPS.PSP_ENC_SUM_TRAN dependencies on PAY_ELEMENT_TYPES_F

Line 7089: l_element_name pay_element_types_f.element_name%TYPE;

7085: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
7086: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
7087: l_full_name per_all_people_f.full_name%TYPE;
7088: l_organization_name hr_organization_units.name%TYPE;
7089: l_element_name pay_element_types_f.element_name%TYPE;
7090: l_project_number pa_projects_all.segment1%TYPE;
7091: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; -- Bug 16391366 (27/03/2013)
7092: l_award_number gms_awards_all.award_number%TYPE;
7093: l_exp_org_name hr_organization_units.name%TYPE;

Line 7150: FROM pay_element_types_f

7146: WHERE organization_id = p_expenditure_org_id;
7147:
7148: CURSOR element_name_cur (p_element_type_id IN NUMBER) IS
7149: SELECT element_name
7150: FROM pay_element_types_f
7151: WHERE element_type_id = p_element_type_id
7152: AND ROWNUM = 1;
7153: BEGIN
7154: l_request_id := fnd_global.conc_request_id;