APPS.PA_REPORT_UTIL dependencies on PA_REP_UTIL_MGR_ORG_V

Line 779: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;

775: l_exist VARCHAR2(1) := 'N';
776: l_period_type pa_rep_period_types_v.period_type_desc%type;
777: l_period_name pa_rep_periods_v.period_name%TYPE;
778: l_org_id pa_rep_util_res_orgs_v.organization_id%TYPE;
779: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;
780: l_orgz_id pa_rep_util_res_orgs_v.organization_id%TYPE;
781: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;
782: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;
783: l_glb_wek_dt pa_rep_periods_v.ge_week_dt%type;

Line 811: FROM pa_rep_util_mgr_org_v

807: l_mgnr_id := p_mgr_id;
808: ELSIF (p_calling_mode = 'ORGMGR') THEN
809: SELECT manager_id
810: INTO l_mgr_id
811: FROM pa_rep_util_mgr_org_v
812: WHERE manager_name = p_mgr_name;
813: l_orgz_id := p_org_id;
814: l_mgnr_id := l_mgr_id;
815: END IF;