APPS.CSTPAPBR dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 239: FROM cst_cost_group_assignments

235: /* Get cost group of the transaction org */
236: BEGIN
237: SELECT NVL(cost_group_id, -1)
238: INTO l_txn_cost_group_id
239: FROM cst_cost_group_assignments
240: WHERE organization_id = l_ae_txn_rec.organization_id;
241: EXCEPTION
242: WHEN no_data_found THEN
243: l_txn_cost_group_id := -1;

Line 433: cst_cost_group_assignments

429: count(organization_id)
430: INTO
431: l_xfer_cg_exists
432: FROM
433: cst_cost_group_assignments
434: WHERE
435: organization_id = nvl(l_ae_txn_rec.xfer_organization_id,-1)
436: AND rownum < 2; /* bug 4586534 added rownum=1 for performance as its only existence check. */
437:

Line 446: cst_cost_group_assignments

442: DECODE (l_ae_txn_rec.xfer_organization_id,NULL,NULL,cost_group_id)
443: INTO
444: l_ae_txn_rec.xfer_cost_group_id
445: FROM
446: cst_cost_group_assignments
447: WHERE
448: organization_id = nvl(l_ae_txn_rec.xfer_organization_id,organization_id);
449: END IF;
450:

Line 635: FROM cst_cost_group_assignments

631:
632: BEGIN
633: SELECT NVL(cost_group_id, -1)
634: INTO l_txn_cost_group_id
635: FROM cst_cost_group_assignments
636: WHERE organization_id = i_ae_txn_rec.organization_id;
637: EXCEPTION
638: WHEN no_data_found THEN
639: l_txn_cost_group_id := -1;

Line 1768: FROM cst_cost_group_assignments

1764: cost group with the transfer transaction org cost group */
1765: BEGIN
1766: SELECT NVL(cost_group_id, -1)
1767: INTO l_txn_cost_group_id
1768: FROM cst_cost_group_assignments
1769: WHERE organization_id = i_ae_txn_rec.organization_id;
1770: EXCEPTION
1771: WHEN no_data_found THEN
1772: l_txn_cost_group_id := -1;

Line 1993: FROM cst_cost_group_assignments

1989: -- changed as a bug found during testing.
1990: BEGIN
1991: SELECT cost_group_id
1992: INTO l_shipping_cg_id
1993: FROM cst_cost_group_assignments
1994: WHERE organization_id = (SELECT decode(i_ae_txn_rec.txn_action_id,
1995: 21, organization_id,
1996: 22, organization_id, -- Logical Shipping txn
1997: 12, transfer_organization_id,

Line 2556: FROM cst_cost_group_assignments

2552: l_stmt_num := 102;
2553:
2554: SELECT NVL(MAX(cost_group_id),-1)
2555: INTO l_txfr_cost_group_id
2556: FROM cst_cost_group_assignments
2557: WHERE organization_id = i_ae_txn_rec.xfer_organization_id;
2558:
2559: l_stmt_num := 104;
2560:

Line 3373: FROM cst_cost_group_assignments

3369: l_stmt_num := 250;
3370:
3371: SELECT NVL(MAX(cost_group_id),-1)
3372: INTO l_txfr_cost_group_id
3373: FROM cst_cost_group_assignments
3374: WHERE organization_id = i_ae_txn_rec.xfer_organization_id;
3375:
3376: l_stmt_num := 255;
3377:

Line 4645: FROM cst_cost_group_assignments

4641: l_stmt_num := 465;
4642:
4643: SELECT NVL(MAX(cost_group_id),-1)
4644: INTO l_txfr_cost_group_id
4645: FROM cst_cost_group_assignments
4646: WHERE organization_id = i_ae_txn_rec.organization_id;
4647:
4648: l_stmt_num := 470;
4649:

Line 7619: FROM cst_cost_group_assignments

7615: l_stmt_num := 5;
7616:
7617: SELECT NVL(cost_group_id, -1)
7618: INTO l_txn_cost_group_id
7619: FROM cst_cost_group_assignments
7620: WHERE organization_id = i_ae_txn_rec.organization_id;
7621: EXCEPTION
7622: WHEN no_data_found THEN
7623: l_txn_cost_group_id := -1;

Line 9023: FROM cst_cost_group_assignments

9019:
9020: BEGIN
9021: SELECT cost_group_id
9022: INTO l_shipping_cg_id
9023: FROM cst_cost_group_assignments
9024: WHERE organization_id = (SELECT decode(i_ae_txn_rec.txn_action_id,
9025: 21, organization_id,
9026: 22, organization_id, -- Logical Shipping txn
9027: 12, transfer_organization_id,

Line 9412: FROM cst_cost_group_assignments

9408: BEGIN
9409: l_stmt_num := 80;
9410: SELECT NVL(cost_group_id, -1)
9411: INTO l_txn_cost_group_id
9412: FROM cst_cost_group_assignments
9413: WHERE organization_id = i_ae_txn_rec.organization_id;
9414: EXCEPTION
9415: WHEN no_data_found THEN
9416: l_txn_cost_group_id := -1;

Line 10269: FROM cst_cost_group_assignments

10265: l_stmt_num := 130;
10266:
10267: SELECT NVL(MAX(cost_group_id),-1)
10268: INTO l_txfr_cost_group_id
10269: FROM cst_cost_group_assignments
10270: WHERE organization_id = i_ae_txn_rec.xfer_organization_id;
10271:
10272: l_stmt_num := 140;
10273: