APPS.PSP_ENC_SUM_TRAN dependencies on PAY_ELEMENT_TYPES_F

Line 6853: l_element_name pay_element_types_f.element_name%TYPE;

6849: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6850: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6851: l_full_name per_all_people_f.full_name%TYPE;
6852: l_organization_name hr_organization_units.name%TYPE;
6853: l_element_name pay_element_types_f.element_name%TYPE;
6854: l_project_number pa_projects_all.segment1%TYPE;
6855: l_task_number pa_tasks.task_number%TYPE;
6856: l_award_number gms_awards_all.award_number%TYPE;
6857: l_exp_org_name hr_organization_units.name%TYPE;

Line 6914: FROM pay_element_types_f

6910: WHERE organization_id = p_expenditure_org_id;
6911:
6912: CURSOR element_name_cur (p_element_type_id IN NUMBER) IS
6913: SELECT element_name
6914: FROM pay_element_types_f
6915: WHERE element_type_id = p_element_type_id
6916: AND ROWNUM = 1;
6917: BEGIN
6918: l_request_id := fnd_global.conc_request_id;