APPS.PA_PROJECT_PUB dependencies on PA_IND_RATE_SCHEDULES

Line 13408: FROM pa_ind_rate_schedules

13404:
13405: BEGIN
13406:
13407: SELECT ind_rate_schedule_type INTO l_rev_rate_sch_type
13408: FROM pa_ind_rate_schedules
13409: WHERE ind_rate_sch_id = p_project_in.REV_IND_RATE_SCH_ID
13410: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
13411:
13412:

Line 13437: FROM pa_ind_rate_schedules

13433: IF l_project_rec.REV_IND_RATE_SCH_ID IS NOT NULL
13434: THEN
13435:
13436: SELECT ind_rate_schedule_type INTO l_rev_rate_sch_type
13437: FROM pa_ind_rate_schedules
13438: WHERE ind_rate_sch_id = l_project_rec.REV_IND_RATE_SCH_ID;
13439: -- Bug 3657709
13440: /* AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate)); */
13441:

Line 13453: FROM pa_ind_rate_schedules

13449:
13450: BEGIN
13451:
13452: SELECT ind_rate_schedule_type INTO l_inv_rate_sch_type
13453: FROM pa_ind_rate_schedules
13454: WHERE ind_rate_sch_id = p_project_in.INV_IND_RATE_SCH_ID
13455: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
13456:
13457:

Line 13481: FROM pa_ind_rate_schedules

13477: IF l_project_rec.INV_IND_RATE_SCH_ID IS NOT NULL
13478: THEN
13479:
13480: SELECT ind_rate_schedule_type INTO l_inv_rate_sch_type
13481: FROM pa_ind_rate_schedules
13482: WHERE ind_rate_sch_id = l_project_rec.INV_IND_RATE_SCH_ID;
13483: -- Bug 3657709
13484: /* AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate)); */
13485: