DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on FND_LOOKUPS

Line 795: FROM fnd_lookups

791: --Get Transaction Status from Lookup
792: BEGIN
793: SELECT lookup_code
794: INTO p_txn_header_rec_type.transaction_status
795: FROM fnd_lookups
796: WHERE lookup_type = 'DPP_TRANSACTION_STATUSES'
797: AND lookup_code = l_txn_status_lookup_code; --ANBBALAS for 12_1_2
798: EXCEPTION
799: WHEN no_data_found THEN

Line 1096: FROM fnd_lookups

1092: --Get line status from lookup
1093: BEGIN
1094: SELECT lookup_code
1095: INTO p_txn_lines_tbl_type(i).line_status
1096: FROM fnd_lookups
1097: WHERE lookup_code = 'ACTIVE'
1098: AND lookup_type = 'DPP_TRANSACTION_STATUSES';
1099: EXCEPTION
1100: WHEN no_data_found THEN

Line 2299: FROM fnd_lookups fl

2295: --Get the Process code for Update Claim and set in the hdr rec type
2296: BEGIN
2297: SELECT fl.lookup_code
2298: INTO l_claim_txn_hdr_rec_type.Process_code
2299: FROM fnd_lookups fl
2300: WHERE fl.lookup_type = 'DPP_EXECUTION_PROCESSES'
2301: AND fl.lookup_code = 'UPDCLM';
2302: EXCEPTION
2303: WHEN no_data_found THEN

Line 3266: FROM fnd_lookups

3262:
3263: BEGIN
3264: SELECT lookup_code
3265: INTO l_status_cancelled
3266: FROM fnd_lookups
3267: WHERE lookup_type = 'DPP_TRANSACTION_STATUSES'
3268: AND lookup_code = 'CANCELLED';
3269: EXCEPTION
3270: WHEN no_data_found THEN