DBA Data[Home] [Help]

APPS.LNS_REP_UTILS dependencies on FND_LOOKUPS

Line 1321: fnd_lookups fl

1317: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1318: LNS_LOOKUPS llkbo,
1319: LNS_LOOKUPS llkrt,
1320: LNS_LOOKUPS llkfc,
1321: fnd_lookups fl
1322: WHERE lfa.FEE_ID = lf.FEE_ID AND
1323: lfa.loan_id = lh.loan_id and
1324: llkfc.lookup_type = 'FEE_CATEGORY' and
1325: llkfc.lookup_code = lf.fee_category and

Line 1347: LNS_LOOKUPS lkps1 , fnd_lookups fl

1343: )
1344: )
1345: )
1346: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1347: LNS_LOOKUPS lkps1 , fnd_lookups fl
1348: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1349: AND lkps1.lookup_type = 'CONDITION_TYPE'
1350: AND lkps1.lookup_code = lc.CONDITION_TYPE
1351: AND fl.lookup_type = 'YES_NO'

Line 1456: fnd_lookups fl

1452: LNS_LOOKUPS lkps1,
1453: LNS_LOOKUPS llkbo,
1454: LNS_LOOKUPS llkrt,
1455: LNS_LOOKUPS llkfc,
1456: fnd_lookups fl
1457: WHERE lfa.FEE_ID = lf.FEE_ID AND
1458: lfa.disb_header_id = ldih.disb_header_id and
1459: llkfc.lookup_type = 'FEE_CATEGORY' and
1460: llkfc.lookup_code = lf.fee_category and

Line 1482: LNS_LOOKUPS lkps1 , fnd_lookups fl

1478: )
1479: )
1480: )
1481: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1482: LNS_LOOKUPS lkps1 , fnd_lookups fl
1483: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1484: AND lkps1.lookup_type = 'CONDITION_TYPE'
1485: AND lkps1.lookup_code = lc.CONDITION_TYPE
1486: AND fl.lookup_type = 'YES_NO'