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 2830: FROM CST_LE_COST_TYPES

2826:
2827: /* The flag selected below indicates if PACP is used or not */
2828: SELECT TRANSFER_COST_FLAG
2829: INTO l_transfer_cost_flag
2830: FROM CST_LE_COST_TYPES
2831: WHERE LEGAL_ENTITY = i_ae_txn_rec.legal_entity_id
2832: AND COST_TYPE_ID = i_ae_txn_rec.cost_type_id;
2833:
2834: l_stmt_num := 102;

Line 2858: FROM cst_le_cost_types

2854: /* See if i_cost_type_id is attached to the transfer LE as well */
2855: l_stmt_num := 106;
2856: SELECT count(*)
2857: INTO l_same_le_ct
2858: FROM cst_le_cost_types
2859: WHERE legal_entity = l_txfr_legal_entity
2860: AND cost_type_id = i_ae_txn_rec.cost_type_id;
2861:
2862: /* Check for the same LE/CT combination */

Line 3637: FROM CST_LE_COST_TYPES

3633: l_stmt_num := 240;
3634:
3635: SELECT TRANSFER_COST_FLAG
3636: INTO l_transfer_cost_flag
3637: FROM CST_LE_COST_TYPES
3638: WHERE LEGAL_ENTITY = i_ae_txn_rec.legal_entity_id
3639: AND COST_TYPE_ID = i_ae_txn_rec.cost_type_id;
3640:
3641: l_stmt_num := 245;

Line 3676: FROM cst_le_cost_types

3672:
3673: /* Check for the same LE/CT combination */
3674: SELECT count(*)
3675: INTO l_same_le_ct
3676: FROM cst_le_cost_types
3677: WHERE legal_entity = l_txfr_legal_entity
3678: AND cost_type_id = i_ae_txn_rec.cost_type_id;
3679:
3680: l_stmt_num := 265;

Line 4910: FROM CST_LE_COST_TYPES

4906: l_stmt_num := 455;
4907:
4908: SELECT TRANSFER_COST_FLAG
4909: INTO l_transfer_cost_flag
4910: FROM CST_LE_COST_TYPES
4911: WHERE LEGAL_ENTITY = i_ae_txn_rec.legal_entity_id
4912: AND COST_TYPE_ID = i_ae_txn_rec.cost_type_id;
4913:
4914: l_stmt_num := 460;

Line 4947: FROM cst_le_cost_types

4943: l_stmt_num := 475;
4944:
4945: SELECT count(*)
4946: INTO l_same_le_ct
4947: FROM cst_le_cost_types
4948: WHERE legal_entity = l_txfr_legal_entity
4949: AND cost_type_id = i_ae_txn_rec.cost_type_id;
4950:
4951: l_stmt_num := 480;

Line 6068: FROM cst_le_cost_types clct

6064:
6065: l_stmt_num := 22;
6066: SELECT nvl(max(primary_cost_method),-1)
6067: INTO l_cost_method
6068: FROM cst_le_cost_types clct
6069: WHERE clct.legal_entity = i_ae_txn_rec.legal_entity_id
6070: AND clct.cost_type_id = i_ae_txn_rec.cost_type_id;
6071:
6072: -- Check if there are Cost Details.

Line 10736: FROM CST_LE_COST_TYPES

10732:
10733: /* The flag selected below indicates if PACP is used or not */
10734: SELECT TRANSFER_COST_FLAG
10735: INTO l_transfer_cost_flag
10736: FROM CST_LE_COST_TYPES
10737: WHERE LEGAL_ENTITY = i_ae_txn_rec.legal_entity_id
10738: AND COST_TYPE_ID = i_ae_txn_rec.cost_type_id;
10739:
10740: l_stmt_num := 130;

Line 10764: FROM cst_le_cost_types

10760: /* See if i_cost_type_id is attached to the transfer LE as well */
10761: l_stmt_num := 150;
10762: SELECT count(*)
10763: INTO l_same_le_ct
10764: FROM cst_le_cost_types
10765: WHERE legal_entity = l_txfr_legal_entity
10766: AND cost_type_id = i_ae_txn_rec.cost_type_id;
10767:
10768: /* Check for the same LE/CT combination */