APPS.CST_PRJMFG_COST_COLLECTOR dependencies on PA_TRANSACTION_SOURCES

Line 3331: From pa_transaction_sources pts1

3327: pts1.transaction_source
3328: into l_transaction_source,
3329: l_inv_txn_src_literal,
3330: l_cap_inv_txn_src_literal
3331: From pa_transaction_sources pts1
3332: Where pts1.transaction_source = 'PJM_CSTBP_INV_NO_ACCOUNTS';
3333: If (l_transaction_source is NULL) then
3334:
3335: RAISE CST_FAILED_TXN_SRC;

Line 3346: From pa_transaction_sources pts1

3342: pts1.transaction_source
3343: into l_transaction_source,
3344: l_inv_txn_src_literal,
3345: l_cap_inv_txn_src_literal
3346: From pa_transaction_sources pts1
3347: Where pts1.transaction_source = 'PJM_CSTBP_INV_ACCOUNTS';
3348:
3349: If (l_transaction_source is NULL ) then
3350:

Line 3364: FROM pa_transaction_sources pts1,

3360: pts2.transaction_source
3361: INTO l_inv_txn_src_literal,
3362: l_transaction_source,
3363: l_cap_inv_txn_src_literal
3364: FROM pa_transaction_sources pts1,
3365: pa_transaction_sources pts2
3366: WHERE pts1.transaction_source = 'Inventory'
3367: AND pts2.transaction_source = 'Inventory Misc';
3368:

Line 3365: pa_transaction_sources pts2

3361: INTO l_inv_txn_src_literal,
3362: l_transaction_source,
3363: l_cap_inv_txn_src_literal
3364: FROM pa_transaction_sources pts1,
3365: pa_transaction_sources pts2
3366: WHERE pts1.transaction_source = 'Inventory'
3367: AND pts2.transaction_source = 'Inventory Misc';
3368:
3369: END IF; /* check for BP org */

Line 3884: From pa_transaction_sources pts1

3880: pts1.transaction_source
3881: into l_transaction_source,
3882: l_inv_txn_src_literal,
3883: l_cap_inv_txn_src_literal
3884: From pa_transaction_sources pts1
3885: Where pts1.transaction_source = 'PJM_CSTBP_INV_NO_ACCOUNTS';
3886: If (l_transaction_source is NULL) then
3887:
3888: RAISE CST_FAILED_TXN_SRC;

Line 3900: From pa_transaction_sources pts1

3896: pts1.transaction_source
3897: into l_transaction_source,
3898: l_inv_txn_src_literal,
3899: l_cap_inv_txn_src_literal
3900: From pa_transaction_sources pts1
3901: Where pts1.transaction_source = 'PJM_CSTBP_INV_ACCOUNTS';
3902:
3903: If (l_transaction_source is NULL ) then
3904:

Line 3918: FROM pa_transaction_sources pts1,

3914: pts2.transaction_source
3915: INTO l_inv_txn_src_literal,
3916: l_transaction_source,
3917: l_cap_inv_txn_src_literal
3918: FROM pa_transaction_sources pts1,
3919: pa_transaction_sources pts2
3920: WHERE pts1.transaction_source = 'Inventory'
3921: AND pts2.transaction_source = 'Inventory Misc';
3922:

Line 3919: pa_transaction_sources pts2

3915: INTO l_inv_txn_src_literal,
3916: l_transaction_source,
3917: l_cap_inv_txn_src_literal
3918: FROM pa_transaction_sources pts1,
3919: pa_transaction_sources pts2
3920: WHERE pts1.transaction_source = 'Inventory'
3921: AND pts2.transaction_source = 'Inventory Misc';
3922:
3923: END IF; /* check for BP org */

Line 4605: From pa_transaction_sources pts1

4601: pts1.transaction_source
4602: into l_transaction_source,
4603: l_inv_txn_src_literal,
4604: l_cap_inv_txn_src_literal
4605: From pa_transaction_sources pts1
4606: Where pts1.transaction_source = 'PJM_CSTBP_INV_NO_ACCOUNTS';
4607: If (l_transaction_source is NULL) then
4608:
4609: RAISE CST_FAILED_TXN_SRC;

Line 4620: From pa_transaction_sources pts1

4616: pts1.transaction_source
4617: into l_transaction_source,
4618: l_inv_txn_src_literal,
4619: l_cap_inv_txn_src_literal
4620: From pa_transaction_sources pts1
4621: Where pts1.transaction_source = 'PJM_CSTBP_INV_ACCOUNTS';
4622:
4623: If (l_transaction_source is NULL ) then
4624:

Line 4636: FROM pa_transaction_sources pts1,

4632: SELECT pts1.transaction_source,
4633: pts2.transaction_source
4634: INTO l_inv_txn_src_literal,
4635: l_cap_inv_txn_src_literal
4636: FROM pa_transaction_sources pts1,
4637: pa_transaction_sources pts2
4638: WHERE pts1.transaction_source = 'Inventory'
4639: AND pts2.transaction_source = 'Inventory Misc';
4640:

Line 4637: pa_transaction_sources pts2

4633: pts2.transaction_source
4634: INTO l_inv_txn_src_literal,
4635: l_cap_inv_txn_src_literal
4636: FROM pa_transaction_sources pts1,
4637: pa_transaction_sources pts2
4638: WHERE pts1.transaction_source = 'Inventory'
4639: AND pts2.transaction_source = 'Inventory Misc';
4640:
4641: SELECT decode(p_type_class,1,

Line 5807: from pa_transaction_sources

5803: /* set the sys linkage to the system linkage to which this transaction source maps to
5804: (usually this transaction source should map to the straight time system linkage) */
5805:
5806: Select NVL(system_linkage_function,c_rec.system_linkage) into l_syslinkage
5807: from pa_transaction_sources
5808: where transaction_source = l_transaction_source;
5809:
5810: else
5811: