APPS.AHL_PP_MATERIALS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 832: FND_LOOKUP_VALUES_VL FLV

828: SELECT DISTINCT
829: AMR.POSITION_KEY, AMR.RELATIONSHIP_ID
830: FROM
831: AHL_MC_RELATIONSHIPS AMR,
832: FND_LOOKUP_VALUES_VL FLV
833: WHERE
834: AMR.POSITION_REF_CODE = FLV.LOOKUP_CODE AND
835: NVL(AMR.ACTIVE_END_DATE,SYSDATE +1 ) > SYSDATE AND
836: FLV.LOOKUP_TYPE = 'AHL_POSITION_REFERENCE' AND

Line 847: FND_LOOKUP_VALUES_VL FLV

843: SELECT DISTINCT
844: AMR.POSITION_KEY, AMR.RELATIONSHIP_ID
845: FROM
846: AHL_MC_RELATIONSHIPS AMR,
847: FND_LOOKUP_VALUES_VL FLV
848: WHERE
849: AMR.POSITION_REF_CODE = FLV.LOOKUP_CODE AND
850: NVL(AMR.ACTIVE_END_DATE,SYSDATE +1 ) > SYSDATE AND
851: FLV.LOOKUP_TYPE = 'AHL_POSITION_REFERENCE' AND

Line 6111: FND_LOOKUP_VALUES_VL FNDA,

6107: SELECT DISTINCT
6108: JRREV.USER_NAME APPROVER_NAME
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'

Line 6126: FND_LOOKUP_VALUES_VL FNDA,

6122: SELECT DISTINCT
6123: JRRV.ROLE_NAME APPROVER_NAME
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'

Line 6141: FND_LOOKUP_VALUES_VL FNDA,

6137: SELECT DISTINCT
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