APPS.PSB_BUDGET_GROUPS_PVT dependencies on PSB_ACCOUNT_POSITION_SETS

Line 2205: SELECT 'PSB_ACCOUNT_POSITION_SETS'

2201: );
2202: l_p1_exists VARCHAR2(1) := FND_API.G_FALSE;
2203:
2204: CURSOR c_p2 IS
2205: SELECT 'PSB_ACCOUNT_POSITION_SETS'
2206: FROM dual
2207: WHERE exists
2208: (SELECT 1
2209: FROM PSB_ACCOUNT_POSITION_SETS

Line 2209: FROM PSB_ACCOUNT_POSITION_SETS

2205: SELECT 'PSB_ACCOUNT_POSITION_SETS'
2206: FROM dual
2207: WHERE exists
2208: (SELECT 1
2209: FROM PSB_ACCOUNT_POSITION_SETS
2210: WHERE budget_group_id = l_budget_group_id
2211: );
2212: l_p2_exists VARCHAR2(1) := FND_API.G_FALSE;
2213: CURSOR c_p3 IS

Line 2403: message_token('TABLE','PSB_ACCOUNT_POSITION_SETS' );

2399: end loop;
2400:
2401: IF FND_API.to_Boolean(l_p2_exists) THEN
2402: rollback to Delete_Row;
2403: message_token('TABLE','PSB_ACCOUNT_POSITION_SETS' );
2404: message_token('BUDGET_GROUP', c1rec.short_name);
2405: add_message('PSB', 'PSB_BG_CANNOT_BE_DELETED');
2406: p_delete := 'NO_DELETE';
2407: raise FND_API.G_EXC_ERROR;

Line 3114: from psb_account_position_sets

3110: loop
3111: l_repeat := nvl(l_repeat,0) + 1;
3112: exit when l_repeat > 10 ;
3113: select count(*) INTO l_count
3114: from psb_account_position_sets
3115: where name = l_name
3116: and account_or_position_type = 'A'
3117: and global_or_local_type = 'G' ;
3118: