DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on PAY_ALL_PAYROLLS_F

Line 7086: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

7082: l_request_id NUMBER(15);
7083: l_person_id NUMBER(15);
7084: l_organization_id NUMBER(15);
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;

Line 7111: FROM pay_all_payrolls_f

7107: AND ROWNUM = 1;
7108:
7109: CURSOR payroll_name_cur (p_payroll_id IN NUMBER) IS
7110: SELECT payroll_name
7111: FROM pay_all_payrolls_f
7112: WHERE payroll_id = p_payroll_id
7113: AND business_group_id = g_business_group_id
7114: AND gl_set_of_books_id = g_set_of_books_id;
7115: