APPS.PSP_GENERAL dependencies on PSP_ORGANIZATION_ACCOUNTS

Line 674: FROM psp_organization_accounts

670: RETURN VARCHAR2 IS
671: --Modified the cursor for bug 2056877,Removed nvl from end_date check.
672: CURSOR global_susp_exists IS
673: SELECT organization_id, organization_account_id,rownum
674: FROM psp_organization_accounts
675: WHERE account_type_code = 'G' AND
676: business_group_id = p_business_group_id AND
677: set_of_books_id = p_set_of_books_id AND
678: (p_start_date_active IS NULL OR

Line 1083: FROM psp_organization_accounts

1079: l_gen_susp_acct NUMBER;
1080: BEGIN
1081: SELECT count(*)
1082: INTO l_gen_susp_acct
1083: FROM psp_organization_accounts
1084: WHERE business_group_id = p_business_group_id;
1085:
1086: IF l_gen_susp_acct > 0 then
1087: return TRUE;