APPS.PA_BILLING_SCHEDULE_UTILS dependencies on PA_ORGANIZATIONS_SBRS_V

Line 588: FROM pa_organizations_sbrs_v o

584:
585: CURSOR c_ids
586: IS
587: SELECT o.organization_id
588: FROM pa_organizations_sbrs_v o
589: WHERE o.schedule_type = 'NON-LABOR'
590: AND o.name = p_org_name;
591:
592: BEGIN

Line 599: FROM pa_organizations_sbrs_v o

595: IF p_check_id_flag = 'Y'
596: THEN
597: SELECT o.organization_id
598: INTO x_org_id
599: FROM pa_organizations_sbrs_v o
600: WHERE o.schedule_type = 'NON-LABOR'
601: AND o.organization_id = p_org_id;
602: ELSIF p_check_id_flag = 'N'
603: THEN

Line 641: FROM pa_organizations_sbrs_v o

637: IF p_org_name IS NOT NULL
638: THEN
639: SELECT o.organization_id
640: INTO x_org_id
641: FROM pa_organizations_sbrs_v o
642: WHERE o.schedule_type = 'NON-LABOR'
643: AND o.name = p_org_name;
644: ELSE
645: x_org_id := null;