APPS.PA_PROJECT_CHECK_PVT dependencies on PA_LOOKUPS

Line 2082: pa_lookups l

2078: CURSOR l_labor_brs_csr (l_org_id IN NUMBER ,l_bill_rate_schdl IN VARCHAR2) IS
2079: SELECT 'x'
2080: FROM
2081: pa_std_bill_rate_schedules brs,
2082: pa_lookups l
2083: WHERE organization_id = l_org_id
2084: AND brs.schedule_type <> 'NON-LABOR'
2085: AND l.lookup_type = 'SCHEDULE TYPE'
2086: AND l.lookup_code (+) = brs.schedule_type

Line 2093: pa_lookups l

2089: CURSOR l_non_labor_brs_csr (l_org_id IN NUMBER,l_bill_rate_schdl IN VARCHAR2) IS
2090: SELECT 'x'
2091: FROM
2092: pa_std_bill_rate_schedules brs,
2093: pa_lookups l
2094: WHERE organization_id = l_org_id
2095: AND brs.schedule_type = 'NON-LABOR'
2096: AND l.lookup_type = 'SCHEDULE TYPE'
2097: AND l.lookup_code (+) = brs.schedule_type

Line 2102: FROM pa_lookups l, pa_ind_rate_schedules irs

2098: AND brs.std_bill_rate_schedule = l_bill_rate_schdl;
2099:
2100: CURSOR l_burden_sch_csr (l_sch_id IN NUMBER ) IS
2101: SELECT 'x'
2102: FROM pa_lookups l, pa_ind_rate_schedules irs
2103: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
2104: AND l.lookup_code = irs.ind_rate_schedule_type
2105: AND irs.ind_rate_sch_id = l_sch_id
2106: AND irs.project_id IS NULL