DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 1812: from okl_lease_applications_b lap,

1808: --START:| 26-JAN-05 cklee - Fixed bug#5002229 |
1809: when pool.source_type_code = 'LEASE_APPLICATION' then
1810: --END| 26-JAN-05 cklee - Fixed bug#5002229 |
1811: (select lap.reference_number
1812: from okl_lease_applications_b lap,
1813: okl_lease_quotes_b lsq
1814: where lsq.parent_object_id = lap.id
1815: and lsq.parent_object_code = 'LEASEAPP'
1816: and lsq.id = pool.source_object_id)

Line 3997: from okl_lease_applications_b lap,

3993: from okl_lease_quotes_b sq
3994: where sq.id = pool.source_object_id)
3995: when pool.source_type_code = 'LEASE_APPLICATION' then
3996: (select lap.reference_number
3997: from okl_lease_applications_b lap,
3998: okl_lease_quotes_b lsq
3999: where lsq.parent_object_id = lap.id
4000: and lsq.parent_object_code = 'LEASEAPP'
4001: and lsq.id = pool.source_object_id)