APPS.CST_PRJMFG_COST_COLLECTOR dependencies on PA_TRANSACTION_SOURCES

Line 3392: From pa_transaction_sources pts1

3388: pts1.transaction_source
3389: into l_transaction_source,
3390: l_inv_txn_src_literal,
3391: l_cap_inv_txn_src_literal
3392: From pa_transaction_sources pts1
3393: Where pts1.transaction_source = 'PJM_CSTBP_INV_NO_ACCOUNTS';
3394: If (l_transaction_source is NULL) then
3395:
3396: RAISE CST_FAILED_TXN_SRC;

Line 3407: From pa_transaction_sources pts1

3403: pts1.transaction_source
3404: into l_transaction_source,
3405: l_inv_txn_src_literal,
3406: l_cap_inv_txn_src_literal
3407: From pa_transaction_sources pts1
3408: Where pts1.transaction_source = 'PJM_CSTBP_INV_ACCOUNTS';
3409:
3410: If (l_transaction_source is NULL ) then
3411:

Line 3425: FROM pa_transaction_sources pts1,

3421: pts2.transaction_source
3422: INTO l_inv_txn_src_literal,
3423: l_transaction_source,
3424: l_cap_inv_txn_src_literal
3425: FROM pa_transaction_sources pts1,
3426: pa_transaction_sources pts2
3427: WHERE pts1.transaction_source = 'Inventory'
3428: AND pts2.transaction_source = 'Inventory Misc';
3429:

Line 3426: pa_transaction_sources pts2

3422: INTO l_inv_txn_src_literal,
3423: l_transaction_source,
3424: l_cap_inv_txn_src_literal
3425: FROM pa_transaction_sources pts1,
3426: pa_transaction_sources pts2
3427: WHERE pts1.transaction_source = 'Inventory'
3428: AND pts2.transaction_source = 'Inventory Misc';
3429:
3430: END IF; /* check for BP org */

Line 3945: From pa_transaction_sources pts1

3941: pts1.transaction_source
3942: into l_transaction_source,
3943: l_inv_txn_src_literal,
3944: l_cap_inv_txn_src_literal
3945: From pa_transaction_sources pts1
3946: Where pts1.transaction_source = 'PJM_CSTBP_INV_NO_ACCOUNTS';
3947: If (l_transaction_source is NULL) then
3948:
3949: RAISE CST_FAILED_TXN_SRC;

Line 3961: From pa_transaction_sources pts1

3957: pts1.transaction_source
3958: into l_transaction_source,
3959: l_inv_txn_src_literal,
3960: l_cap_inv_txn_src_literal
3961: From pa_transaction_sources pts1
3962: Where pts1.transaction_source = 'PJM_CSTBP_INV_ACCOUNTS';
3963:
3964: If (l_transaction_source is NULL ) then
3965:

Line 3979: FROM pa_transaction_sources pts1,

3975: pts2.transaction_source
3976: INTO l_inv_txn_src_literal,
3977: l_transaction_source,
3978: l_cap_inv_txn_src_literal
3979: FROM pa_transaction_sources pts1,
3980: pa_transaction_sources pts2
3981: WHERE pts1.transaction_source = 'Inventory'
3982: AND pts2.transaction_source = 'Inventory Misc';
3983:

Line 3980: pa_transaction_sources pts2

3976: INTO l_inv_txn_src_literal,
3977: l_transaction_source,
3978: l_cap_inv_txn_src_literal
3979: FROM pa_transaction_sources pts1,
3980: pa_transaction_sources pts2
3981: WHERE pts1.transaction_source = 'Inventory'
3982: AND pts2.transaction_source = 'Inventory Misc';
3983:
3984: END IF; /* check for BP org */

Line 4666: From pa_transaction_sources pts1

4662: pts1.transaction_source
4663: into l_transaction_source,
4664: l_inv_txn_src_literal,
4665: l_cap_inv_txn_src_literal
4666: From pa_transaction_sources pts1
4667: Where pts1.transaction_source = 'PJM_CSTBP_INV_NO_ACCOUNTS';
4668: If (l_transaction_source is NULL) then
4669:
4670: RAISE CST_FAILED_TXN_SRC;

Line 4681: From pa_transaction_sources pts1

4677: pts1.transaction_source
4678: into l_transaction_source,
4679: l_inv_txn_src_literal,
4680: l_cap_inv_txn_src_literal
4681: From pa_transaction_sources pts1
4682: Where pts1.transaction_source = 'PJM_CSTBP_INV_ACCOUNTS';
4683:
4684: If (l_transaction_source is NULL ) then
4685:

Line 4697: FROM pa_transaction_sources pts1,

4693: SELECT pts1.transaction_source,
4694: pts2.transaction_source
4695: INTO l_inv_txn_src_literal,
4696: l_cap_inv_txn_src_literal
4697: FROM pa_transaction_sources pts1,
4698: pa_transaction_sources pts2
4699: WHERE pts1.transaction_source = 'Inventory'
4700: AND pts2.transaction_source = 'Inventory Misc';
4701:

Line 4698: pa_transaction_sources pts2

4694: pts2.transaction_source
4695: INTO l_inv_txn_src_literal,
4696: l_cap_inv_txn_src_literal
4697: FROM pa_transaction_sources pts1,
4698: pa_transaction_sources pts2
4699: WHERE pts1.transaction_source = 'Inventory'
4700: AND pts2.transaction_source = 'Inventory Misc';
4701:
4702: SELECT decode(p_type_class,1,

Line 5874: from pa_transaction_sources

5870: /* set the sys linkage to the system linkage to which this transaction source maps to
5871: (usually this transaction source should map to the straight time system linkage) */
5872:
5873: Select NVL(system_linkage_function,c_rec.system_linkage) into l_syslinkage
5874: from pa_transaction_sources
5875: where transaction_source = l_transaction_source;
5876:
5877: else
5878: