DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on PAY_ALL_PAYROLLS_F

Line 6850: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

6846: l_request_id NUMBER(15);
6847: l_person_id NUMBER(15);
6848: l_organization_id NUMBER(15);
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;

Line 6875: FROM pay_all_payrolls_f

6871: AND ROWNUM = 1;
6872:
6873: CURSOR payroll_name_cur (p_payroll_id IN NUMBER) IS
6874: SELECT payroll_name
6875: FROM pay_all_payrolls_f
6876: WHERE payroll_id = p_payroll_id
6877: AND business_group_id = g_business_group_id
6878: AND gl_set_of_books_id = g_set_of_books_id;
6879: