APPS.PA_REPORT_UTIL dependencies on PA_REP_UTIL_MGR_ORG_V

Line 746: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;

742: l_exist VARCHAR2(1) := 'N';
743: l_period_type pa_rep_period_types_v.period_type_desc%type;
744: l_period_name pa_rep_periods_v.period_name%TYPE;
745: l_org_id pa_rep_util_res_orgs_v.organization_id%TYPE;
746: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;
747: l_orgz_id pa_rep_util_res_orgs_v.organization_id%TYPE;
748: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;
749: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;
750: l_glb_wek_dt pa_rep_periods_v.ge_week_dt%type;

Line 778: FROM pa_rep_util_mgr_org_v

774: l_mgnr_id := p_mgr_id;
775: ELSIF (p_calling_mode = 'ORGMGR') THEN
776: SELECT manager_id
777: INTO l_mgr_id
778: FROM pa_rep_util_mgr_org_v
779: WHERE manager_name = p_mgr_name;
780: l_orgz_id := p_org_id;
781: l_mgnr_id := l_mgr_id;
782: END IF;