APPS.FII_EA_UTIL_PKG dependencies on FND_GLOBAL

Line 1134: WHERE sec.user_id = fnd_global.user_id

1130:
1131: CURSOR company_cursor IS
1132: SELECT sec.company_id company_id, sec.aggregated_flag agg_flag
1133: FROM fii_company_grants sec
1134: WHERE sec.user_id = fnd_global.user_id
1135: and report_region_code = g_region_code;
1136:
1137: -- definition of cost center cursor
1138:

Line 1142: WHERE sec.user_id = fnd_global.user_id

1138:
1139: CURSOR cost_center_cursor IS
1140: SELECT sec.cost_center_id cc_id, sec.aggregated_flag agg_flag
1141: FROM fii_cost_center_grants sec
1142: WHERE sec.user_id = fnd_global.user_id
1143: and report_region_code = g_region_code;
1144:
1145: BEGIN
1146:

Line 1456: WHERE user_id = fnd_global.user_id

1452: --------------------1st case--- both company and CC param All ------------------------
1453: IF g_company_id = 'All' THEN
1454: SELECT count(*) INTO g_company_count
1455: FROM fii_company_grants
1456: WHERE user_id = fnd_global.user_id
1457: and report_region_code = g_region_code;
1458:
1459: IF g_cost_center_id = 'All' THEN
1460: SELECT count(*) INTO g_cc_count

Line 1462: WHERE user_id = fnd_global.user_id

1458:
1459: IF g_cost_center_id = 'All' THEN
1460: SELECT count(*) INTO g_cc_count
1461: FROM fii_cost_center_grants
1462: WHERE user_id = fnd_global.user_id
1463: and report_region_code = g_region_code;
1464:
1465: FOR i in company_cursor LOOP
1466: FOR j in cost_center_cursor LOOP

Line 1527: WHERE user_id=fnd_global.user_id

1523: IF g_cost_center_id = 'All' THEN
1524: -------------------- 3rd case...------ specific company and Cost Center - All is chosen------------------------------
1525: SELECT count(*) INTO g_cc_count
1526: FROM fii_cost_center_grants
1527: WHERE user_id=fnd_global.user_id
1528: and report_region_code = g_region_code;
1529:
1530: FOR j in cost_center_cursor LOOP
1531: