APPS.PA_PROJECT_PUB dependencies on PA_IND_RATE_SCHEDULES

Line 13728: FROM pa_ind_rate_schedules

13724:
13725: BEGIN
13726:
13727: SELECT ind_rate_schedule_type INTO l_rev_rate_sch_type
13728: FROM pa_ind_rate_schedules
13729: WHERE ind_rate_sch_id = p_project_in.REV_IND_RATE_SCH_ID
13730: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
13731:
13732:

Line 13757: FROM pa_ind_rate_schedules

13753: IF l_project_rec.REV_IND_RATE_SCH_ID IS NOT NULL
13754: THEN
13755:
13756: SELECT ind_rate_schedule_type INTO l_rev_rate_sch_type
13757: FROM pa_ind_rate_schedules
13758: WHERE ind_rate_sch_id = l_project_rec.REV_IND_RATE_SCH_ID;
13759: -- Bug 3657709
13760: /* AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate)); */
13761:

Line 13773: FROM pa_ind_rate_schedules

13769:
13770: BEGIN
13771:
13772: SELECT ind_rate_schedule_type INTO l_inv_rate_sch_type
13773: FROM pa_ind_rate_schedules
13774: WHERE ind_rate_sch_id = p_project_in.INV_IND_RATE_SCH_ID
13775: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
13776:
13777:

Line 13801: FROM pa_ind_rate_schedules

13797: IF l_project_rec.INV_IND_RATE_SCH_ID IS NOT NULL
13798: THEN
13799:
13800: SELECT ind_rate_schedule_type INTO l_inv_rate_sch_type
13801: FROM pa_ind_rate_schedules
13802: WHERE ind_rate_sch_id = l_project_rec.INV_IND_RATE_SCH_ID;
13803: -- Bug 3657709
13804: /* AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate)); */
13805: