APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_APPROVAL_RULES_B

Line 6096: FROM AHL_APPROVAL_RULES_B A,AHL_APPROVERS_V B

6092: A.APPROVAL_OBJECT_CODE,
6093: A.STATUS_CODE,
6094: B.APPROVER_NAME,
6095: B.APPROVER_SEQUENCE
6096: FROM AHL_APPROVAL_RULES_B A,AHL_APPROVERS_V B
6097: WHERE A.APPROVAL_RULE_ID=B.APPROVAL_RULE_ID
6098: AND A.STATUS_CODE='ACTIVE'
6099: AND A.APPROVAL_OBJECT_CODE=c_object_type
6100: ORDER BY B.APPROVER_SEQUENCE;

Line 6113: AHL_APPROVAL_RULES_B APR

6109: FROM
6110: AHL_APPROVERS AA,
6111: FND_LOOKUP_VALUES_VL FNDA,
6112: AHL_JTF_RS_EMP_V JRREV,
6113: AHL_APPROVAL_RULES_B APR
6114: WHERE
6115: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
6116: AND FNDA.LOOKUP_CODE = AA.APPROVER_TYPE_CODE
6117: AND AA.APPROVER_TYPE_CODE = 'USER'

Line 6128: AHL_APPROVAL_RULES_B APR

6124: FROM
6125: AHL_APPROVERS AA,
6126: FND_LOOKUP_VALUES_VL FNDA,
6127: JTF_RS_ROLE_RELATIONS_VL JRRV,
6128: AHL_APPROVAL_RULES_B APR
6129: WHERE
6130: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
6131: AND FNDA.LOOKUP_CODE = AA.APPROVER_TYPE_CODE
6132: AND AA.APPROVER_TYPE_CODE = 'ROLE'

Line 6142: AHL_APPROVAL_RULES_B APR

6138: '' APPROVER_NAME
6139: FROM
6140: AHL_APPROVERS AA,
6141: FND_LOOKUP_VALUES_VL FNDA,
6142: AHL_APPROVAL_RULES_B APR
6143: WHERE
6144: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
6145: AND FNDA.LOOKUP_CODE = AA.APPROVER_TYPE_CODE
6146: AND AA.APPROVER_TYPE_CODE = 'ROLE'