[Home] [Help]
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
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;
3279: RETURN NUMBER
3280: IS
3281: CURSOR c_Organization_Default_Account IS
3282: SELECT 1
3283: FROM psp_organization_accounts
3284: WHERE project_id = nvl (p_project_id, project_id)
3285: AND task_id = nvl (p_task_id, task_id)
3286: AND account_type_code = 'D'
3287: AND project_id IS NOT NULL
3321: RETURN NUMBER
3322: IS
3323: CURSOR c_Suspense_Account_Level IS
3324: SELECT 1
3325: FROM psp_organization_accounts
3326: WHERE project_id = nvl (p_project_id, project_id)
3327: AND task_id = nvl (p_task_id, task_id)
3328: AND account_type_code = 'S'
3329: AND project_id IS NOT NULL
3364: RETURN NUMBER
3365: IS
3366: CURSOR c_Generic_Susp_Account_Level is
3367: SELECT 1
3368: FROM psp_organization_accounts
3369: WHERE project_id = nvl (p_project_id, project_id)
3370: AND task_id = nvl (p_task_id, task_id)
3371: AND account_type_code = 'G'
3372: AND project_id is NOT NULL
3405: FUNCTION chk_Org_Excess_Salary_Account
3406: RETURN NUMBER IS
3407: CURSOR c_Org_Excess_Salary_Account IS
3408: SELECT 1
3409: FROM psp_organization_accounts
3410: WHERE project_id = nvl (p_project_id, project_id)
3411: AND task_id = nvl (p_task_id, task_id)
3412: AND account_type_code = 'ORG_EXCESS'
3413: AND project_id is NOT NULL