APPS.PA_PROJECT_CHECK_PVT dependencies on PA_STD_BILL_RATE_SCHEDULES

Line 2004: pa_std_bill_rate_schedules brs

2000: /* Commented for Bug No 4721987
2001: CURSOR l_labor_bill_rate_org_csr (l_org_id IN NUMBER ) IS
2002: SELECT 'x' FROM
2003: pa_organizations_v o,
2004: pa_std_bill_rate_schedules brs
2005: WHERE o.organization_id = l_org_id
2006: AND o.organization_id = brs.organization_id
2007: AND brs.schedule_type <> 'NON-LABOR';*/
2008:

Line 2015: pa_std_bill_rate_schedules brs

2011:
2012: /*CURSOR l_job_brs_csr (l_job_rate_schdid IN NUMBER) IS
2013: SELECT 'x'
2014: FROM
2015: pa_std_bill_rate_schedules brs
2016: WHERE brs.schedule_type = 'JOB'
2017: AND brs.BILL_RATE_SCH_ID = l_job_rate_schdid;
2018:
2019: CURSOR l_emp_brs_csr (l_emp_rate_schdid IN NUMBER) IS

Line 2022: pa_std_bill_rate_schedules brs

2018:
2019: CURSOR l_emp_brs_csr (l_emp_rate_schdid IN NUMBER) IS
2020: SELECT 'x'
2021: FROM
2022: pa_std_bill_rate_schedules brs
2023: WHERE brs.schedule_type = 'EMPLOYEE'
2024: AND brs.BILL_RATE_SCH_ID = l_emp_rate_schdid;*/
2025:
2026: CURSOR l_job_brs_csr( l_job_rate_schdid NUMBER)

Line 2029: FROM pa_std_bill_rate_schedules_all brs, pa_project_types_all pt, pa_projects pa

2025:
2026: CURSOR l_job_brs_csr( l_job_rate_schdid NUMBER)
2027: IS
2028: SELECT 'x'
2029: FROM pa_std_bill_rate_schedules_all brs, pa_project_types_all pt, pa_projects pa
2030: WHERE bill_rate_sch_id = l_job_rate_schdid
2031: AND pa.project_id = l_project_id
2032: AND brs.job_group_id = pt.bill_job_group_id
2033: and brs.schedule_type = 'JOB'

Line 2050: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa

2046:
2047: CURSOR l_emp_brs_csr( l_emp_rate_schdid NUMBER)
2048: IS
2049: SELECT 'x'
2050: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa
2051: WHERE brs.bill_rate_sch_id = l_emp_rate_schdid
2052: AND pa.project_id = l_project_id
2053: and brs.schedule_type = 'EMPLOYEE'
2054: AND ( pa.multi_currency_BILLING_flag = 'Y'

Line 2072: pa_std_bill_rate_schedules brs

2068:
2069: CURSOR l_non_labor_bill_rate_org_csr (l_org_id IN NUMBER ) IS
2070: SELECT 'x' FROM
2071: pa_organizations_v o,
2072: pa_std_bill_rate_schedules brs
2073: WHERE o.organization_id = l_org_id
2074: AND o.organization_id = brs.organization_id
2075: AND brs.schedule_type = 'NON-LABOR';
2076:

Line 2081: pa_std_bill_rate_schedules brs,

2077: /* Commented for Bug no 4721987
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'

Line 2092: pa_std_bill_rate_schedules brs,

2088:
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'