DBA Data[Home] [Help]

APPS.LNS_REP_UTILS dependencies on FND_LOOKUPS

Line 1415: fnd_lookups fl

1411: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1412: LNS_LOOKUPS llkbo,
1413: LNS_LOOKUPS llkrt,
1414: LNS_LOOKUPS llkfc,
1415: fnd_lookups fl
1416: WHERE lfa.FEE_ID = lf.FEE_ID AND
1417: lfa.loan_id = lh.loan_id and
1418: llkfc.lookup_type = 'FEE_CATEGORY' and
1419: llkfc.lookup_code = lf.fee_category and

Line 1441: LNS_LOOKUPS lkps1 , fnd_lookups fl

1437: )
1438: )
1439: )
1440: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1441: LNS_LOOKUPS lkps1 , fnd_lookups fl
1442: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1443: AND lkps1.lookup_type = 'CONDITION_TYPE'
1444: AND lkps1.lookup_code = lc.CONDITION_TYPE
1445: AND fl.lookup_type = 'YES_NO'

Line 1550: fnd_lookups fl

1546: LNS_LOOKUPS lkps1,
1547: LNS_LOOKUPS llkbo,
1548: LNS_LOOKUPS llkrt,
1549: LNS_LOOKUPS llkfc,
1550: fnd_lookups fl
1551: WHERE lfa.FEE_ID = lf.FEE_ID AND
1552: lfa.disb_header_id = ldih.disb_header_id and
1553: llkfc.lookup_type = 'FEE_CATEGORY' and
1554: llkfc.lookup_code = lf.fee_category and

Line 1576: LNS_LOOKUPS lkps1 , fnd_lookups fl

1572: )
1573: )
1574: )
1575: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1576: LNS_LOOKUPS lkps1 , fnd_lookups fl
1577: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1578: AND lkps1.lookup_type = 'CONDITION_TYPE'
1579: AND lkps1.lookup_code = lc.CONDITION_TYPE
1580: AND fl.lookup_type = 'YES_NO'