APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_APPROVAL_RULES_B

Line 4533: FROM AHL_APPROVAL_RULES_B A,AHL_APPROVERS_V B

4529: A.APPROVAL_OBJECT_CODE,
4530: A.STATUS_CODE,
4531: B.APPROVER_NAME,
4532: B.APPROVER_SEQUENCE
4533: FROM AHL_APPROVAL_RULES_B A,AHL_APPROVERS_V B
4534: WHERE A.APPROVAL_RULE_ID=B.APPROVAL_RULE_ID
4535: AND A.STATUS_CODE='ACTIVE'
4536: AND A.APPROVAL_OBJECT_CODE=c_object_type
4537: ORDER BY B.APPROVER_SEQUENCE;

Line 4550: AHL_APPROVAL_RULES_B APR

4546: FROM
4547: AHL_APPROVERS AA,
4548: FND_LOOKUP_VALUES_VL FNDA,
4549: AHL_JTF_RS_EMP_V JRREV,
4550: AHL_APPROVAL_RULES_B APR
4551: WHERE
4552: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
4553: AND FNDA.LOOKUP_CODE = AA.APPROVER_TYPE_CODE
4554: AND AA.APPROVER_TYPE_CODE = 'USER'

Line 4565: AHL_APPROVAL_RULES_B APR

4561: FROM
4562: AHL_APPROVERS AA,
4563: FND_LOOKUP_VALUES_VL FNDA,
4564: JTF_RS_ROLE_RELATIONS_VL JRRV,
4565: AHL_APPROVAL_RULES_B APR
4566: WHERE
4567: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
4568: AND FNDA.LOOKUP_CODE = AA.APPROVER_TYPE_CODE
4569: AND AA.APPROVER_TYPE_CODE = 'ROLE'

Line 4579: AHL_APPROVAL_RULES_B APR

4575: '' APPROVER_NAME
4576: FROM
4577: AHL_APPROVERS AA,
4578: FND_LOOKUP_VALUES_VL FNDA,
4579: AHL_APPROVAL_RULES_B APR
4580: WHERE
4581: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
4582: AND FNDA.LOOKUP_CODE = AA.APPROVER_TYPE_CODE
4583: AND AA.APPROVER_TYPE_CODE = 'ROLE'