APPS.PA_AGREEMENT_CORE dependencies on PA_ORGANIZATIONS_PROJECT_V

Line 1329: FROM pa_organizations_project_v

1325:
1326: l_valid_flag VARCHAR2(1);
1327: BEGIN
1328: SELECT 'Y' INTO l_valid_flag
1329: FROM pa_organizations_project_v
1330: WHERE organization_id = p_owning_organization_id
1331: AND SYSDATE BETWEEN DECODE (date_from, NULL, SYSDATE, date_from)
1332: AND DECODE(date_to, NULL, SYSDATE,date_to);
1333: RETURN 'Y';