APPS.OKL_SO_CREDIT_APP_WF dependencies on FND_PROFILE

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

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

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

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

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

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