439: dummy NUMBER;
440: BEGIN
441: SELECT count(1)
442: INTO dummy 443: FROM pa_organizations_v 444: WHERE organization_id = X_nl_resource_org_id
445: AND X_ei_date between date_from and nvl(date_to,X_ei_date);
446: IF ( dummy = 0 ) THEN
447: IF pa_trx_import.g_skip_tc_flag <> 'Y' then /* Added for Bug # 2170237 */