APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT dependencies on FND_PROFILE

Line 350: AND mr.application_usg_code = FND_PROFILE.VALUE('AHL_APPLN_USAGE')

346: (c_effective_to IS NULL
347: OR (TRUNC(c_effective_to) < TRUNC(NVL(MR.effective_to,sysdate+1))))
348: AND mr.mr_status_code IN ('DRAFT','COMPLETE','APPROVAL_PENDING')
349: AND mr.repetitive_flag = 'Y'
350: AND mr.application_usg_code = FND_PROFILE.VALUE('AHL_APPLN_USAGE')
351: ORDER BY rel.start_mr_relationship_id,
352: rel.sequence_number;
353:
354: l_loop_chain_rec get_loop_chain_relns%ROWTYPE;