APPS.CSTPAPBR dependencies on CST_LE_COST_TYPES

Line 81: cst_le_cost_types clct

77: set_of_books_id
78: INTO
79: l_ae_txn_rec.set_of_books_id
80: FROM
81: cst_le_cost_types clct
82: WHERE
83: clct.legal_entity = i_legal_entity AND
84: clct.cost_type_id = i_cost_type_id;
85:

Line 2548: FROM CST_LE_COST_TYPES

2544:
2545: /* The flag selected below indicates if PACP is used or not */
2546: SELECT TRANSFER_COST_FLAG
2547: INTO l_transfer_cost_flag
2548: FROM CST_LE_COST_TYPES
2549: WHERE LEGAL_ENTITY = i_ae_txn_rec.legal_entity_id
2550: AND COST_TYPE_ID = i_ae_txn_rec.cost_type_id;
2551:
2552: l_stmt_num := 102;

Line 2576: FROM cst_le_cost_types

2572: /* See if i_cost_type_id is attached to the transfer LE as well */
2573: l_stmt_num := 106;
2574: SELECT count(*)
2575: INTO l_same_le_ct
2576: FROM cst_le_cost_types
2577: WHERE legal_entity = l_txfr_legal_entity
2578: AND cost_type_id = i_ae_txn_rec.cost_type_id;
2579:
2580: /* Check for the same LE/CT combination */

Line 3355: FROM CST_LE_COST_TYPES

3351: l_stmt_num := 240;
3352:
3353: SELECT TRANSFER_COST_FLAG
3354: INTO l_transfer_cost_flag
3355: FROM CST_LE_COST_TYPES
3356: WHERE LEGAL_ENTITY = i_ae_txn_rec.legal_entity_id
3357: AND COST_TYPE_ID = i_ae_txn_rec.cost_type_id;
3358:
3359: l_stmt_num := 245;

Line 3394: FROM cst_le_cost_types

3390:
3391: /* Check for the same LE/CT combination */
3392: SELECT count(*)
3393: INTO l_same_le_ct
3394: FROM cst_le_cost_types
3395: WHERE legal_entity = l_txfr_legal_entity
3396: AND cost_type_id = i_ae_txn_rec.cost_type_id;
3397:
3398: l_stmt_num := 265;

Line 4628: FROM CST_LE_COST_TYPES

4624: l_stmt_num := 455;
4625:
4626: SELECT TRANSFER_COST_FLAG
4627: INTO l_transfer_cost_flag
4628: FROM CST_LE_COST_TYPES
4629: WHERE LEGAL_ENTITY = i_ae_txn_rec.legal_entity_id
4630: AND COST_TYPE_ID = i_ae_txn_rec.cost_type_id;
4631:
4632: l_stmt_num := 460;

Line 4665: FROM cst_le_cost_types

4661: l_stmt_num := 475;
4662:
4663: SELECT count(*)
4664: INTO l_same_le_ct
4665: FROM cst_le_cost_types
4666: WHERE legal_entity = l_txfr_legal_entity
4667: AND cost_type_id = i_ae_txn_rec.cost_type_id;
4668:
4669: l_stmt_num := 480;

Line 5786: FROM cst_le_cost_types clct

5782:
5783: l_stmt_num := 22;
5784: SELECT nvl(max(primary_cost_method),-1)
5785: INTO l_cost_method
5786: FROM cst_le_cost_types clct
5787: WHERE clct.legal_entity = i_ae_txn_rec.legal_entity_id
5788: AND clct.cost_type_id = i_ae_txn_rec.cost_type_id;
5789:
5790: -- Check if there are Cost Details.

Line 10261: FROM CST_LE_COST_TYPES

10257:
10258: /* The flag selected below indicates if PACP is used or not */
10259: SELECT TRANSFER_COST_FLAG
10260: INTO l_transfer_cost_flag
10261: FROM CST_LE_COST_TYPES
10262: WHERE LEGAL_ENTITY = i_ae_txn_rec.legal_entity_id
10263: AND COST_TYPE_ID = i_ae_txn_rec.cost_type_id;
10264:
10265: l_stmt_num := 130;

Line 10289: FROM cst_le_cost_types

10285: /* See if i_cost_type_id is attached to the transfer LE as well */
10286: l_stmt_num := 150;
10287: SELECT count(*)
10288: INTO l_same_le_ct
10289: FROM cst_le_cost_types
10290: WHERE legal_entity = l_txfr_legal_entity
10291: AND cost_type_id = i_ae_txn_rec.cost_type_id;
10292:
10293: /* Check for the same LE/CT combination */