APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_APPROVERS

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 4541: * Balaji blown open AHL_APPROVERS_V since it introduces NMV

4537: ORDER BY B.APPROVER_SEQUENCE;
4538: */
4539: /*
4540: * R12 Perf Tuning
4541: * Balaji blown open AHL_APPROVERS_V since it introduces NMV
4542: * due to Unions in the query. Reference bug # 4919273 and 4919045
4543: */
4544: SELECT DISTINCT
4545: JRREV.USER_NAME APPROVER_NAME

Line 4547: AHL_APPROVERS AA,

4543: */
4544: SELECT DISTINCT
4545: JRREV.USER_NAME APPROVER_NAME
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

Line 4562: AHL_APPROVERS AA,

4558: UNION
4559: SELECT DISTINCT
4560: JRRV.ROLE_NAME APPROVER_NAME
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

Line 4577: AHL_APPROVERS AA,

4573: UNION
4574: SELECT DISTINCT
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'