APPS.AS_RTTAP_ACCOUNT dependencies on FND_PROFILE

Line 351: IF NVL(FND_PROFILE.Value('AS_ENABLE_CUST_ONLINE_TAP'), 'N') <> 'Y' THEN

347:
348: -- Initialize API return status to SUCCESS
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: IF NVL(FND_PROFILE.Value('AS_ENABLE_CUST_ONLINE_TAP'), 'N') <> 'Y' THEN
352: /*------------------------------------------------------+
353: | If REALTIME TAP profile is turned on there is NO need
354: | to insert into changed accounts since the ACCOUNT is
355: | processed immediately.

Line 976: FROM FND_PROFILE_OPTION_VALUES VAL,

972: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
973: AND ACC.sales_group_id = p_WinningTerrMember_tbl.group_id(l_index) ) ) asa,
974: ( SELECT USERS.EMPLOYEE_ID EMPLOYEE_ID ,
975: VAL.PROFILE_OPTION_VALUE SALESFORCE_ROLE_CODE
976: FROM FND_PROFILE_OPTION_VALUES VAL,
977: FND_PROFILE_OPTIONS OPTIONS,
978: FND_USER USERS
979: WHERE VAL.LEVEL_ID = 10004
980: AND USERS.EMPLOYEE_ID is not null

Line 977: FND_PROFILE_OPTIONS OPTIONS,

973: AND ACC.sales_group_id = p_WinningTerrMember_tbl.group_id(l_index) ) ) asa,
974: ( SELECT USERS.EMPLOYEE_ID EMPLOYEE_ID ,
975: VAL.PROFILE_OPTION_VALUE SALESFORCE_ROLE_CODE
976: FROM FND_PROFILE_OPTION_VALUES VAL,
977: FND_PROFILE_OPTIONS OPTIONS,
978: FND_USER USERS
979: WHERE VAL.LEVEL_ID = 10004
980: AND USERS.EMPLOYEE_ID is not null
981: AND VAL.PROFILE_OPTION_VALUE is not null