APPS.OKL_SO_CREDIT_APP_WF dependencies on FND_PROFILE

Line 236: (select 1 num, FND_PROFILE.VALUE('OKL_CREDIT_ANALYST') role,

232:
233: CURSOR C_APPROVER_DISPLAY_NAME IS
234: select role, name
235: from
236: (select 1 num, FND_PROFILE.VALUE('OKL_CREDIT_ANALYST') role,
237: NVL(PER.FULL_NAME, USR.USER_NAME) name
238: from FND_USER USR, PER_PEOPLE_F PER
239: where USR.USER_NAME = FND_PROFILE.VALUE('OKL_CREDIT_ANALYST')
240: and USR.EMPLOYEE_ID = PER.PERSON_ID(+)

Line 239: where USR.USER_NAME = FND_PROFILE.VALUE('OKL_CREDIT_ANALYST')

235: from
236: (select 1 num, FND_PROFILE.VALUE('OKL_CREDIT_ANALYST') role,
237: NVL(PER.FULL_NAME, USR.USER_NAME) name
238: from FND_USER USR, PER_PEOPLE_F PER
239: where USR.USER_NAME = FND_PROFILE.VALUE('OKL_CREDIT_ANALYST')
240: and USR.EMPLOYEE_ID = PER.PERSON_ID(+)
241: and trunc(sysdate) between nvl(per.effective_start_date, trunc(sysdate)) and
242: nvl(per.effective_end_date, trunc(sysdate))
243: );

Line 722: OPEN c_approver_user_id(FND_PROFILE.VALUE('OKL_CREDIT_ANALYST'));

718: return;
719: END IF;
720: CLOSE c_get_inv_org_id;
721:
722: OPEN c_approver_user_id(FND_PROFILE.VALUE('OKL_CREDIT_ANALYST'));
723: FETCH c_approver_user_id INTO l_approved_by;
724: close c_approver_user_id;
725:
726: -- get credit checklist.