DBA Data[Home] [Help]

APPS.PA_PROJECT_CHECK_PVT dependencies on PA_STD_BILL_RATE_SCHEDULES_ALL

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'