APPS.PQH_GL_POSTING dependencies on HR_ALL_ORGANIZATION_UNITS

Line 3940: hr_all_organization_units org

3936:
3937: CURSOR csr_cost_allocation_keyflex_id IS
3938: SELECT cost_allocation_keyflex_id
3939: FROM pqh_budget_details bdt,
3940: hr_all_organization_units org
3941: WHERE bdt.budget_detail_id = p_budget_detail_id
3942: AND bdt.organization_id = org.organization_id;
3943:
3944:

Line 5783: l_org_name hr_all_organization_units_tl.name%TYPE;

5779: */
5780:
5781: ---------------Local Variables---------------------------------------------
5782: l_bg_id NUMBER(15) ;
5783: l_org_name hr_all_organization_units_tl.name%TYPE;
5784: l_seg1 VARCHAR2(25);
5785: l_task_number pa_tasks.task_number%TYPE;
5786: l_gms_batch_name VARCHAR2(10);
5787: l_exp_end_dt DATE;