APPS.PATC dependencies on PA_ORGANIZATIONS_V

Line 410: FROM pa_organizations_v

406: dummy NUMBER;
407: BEGIN
408: SELECT count(1)
409: INTO dummy
410: FROM pa_organizations_v
411: WHERE organization_id = X_nl_resource_org_id
412: AND X_ei_date between date_from and nvl(date_to,X_ei_date);
413: IF ( dummy = 0 ) THEN
414: IF pa_trx_import.g_skip_tc_flag <> 'Y' then /* Added for Bug # 2170237 */