APPS.CST_PRJMFG_COST_COLLECTOR dependencies on DUAL

Line 667: FROM dual;

663: l_stmt_num := 10;
664:
665: SELECT mtl_material_transactions_s.nextval
666: INTO p_group_id
667: FROM dual;
668:
669: l_stmt_num := 20;
670:
671: FOR sel_mmt_rec IN sel_mmt_trx( p_Org_Id,

Line 1279: FROM dual;

1275: l_stmt_num := 10;
1276:
1277: SELECT wip_transactions_S.nextval
1278: INTO l_group_id
1279: FROM dual;
1280:
1281: p_group_id := l_group_id;
1282: l_stmt_num := 20;
1283:

Line 1596: FROM DUAL;

1592: 4, 4, --RES ABSO;OSP
1593: 5, 3, --OVHD ABSO
1594: 4))
1595: INTO l_accounting_line_type
1596: FROM DUAL;
1597:
1598: l_stmt_num := 14;
1599:
1600: /* Bug 2599649

Line 2701: FROM DUAL;

2697:
2698: SELECT 'CC'|| substr( replace( lpad(
2699: to_char(p_Group_Id,'9999999999999'),14,'0') ,' ','0'),-8)
2700: INTO l_batch
2701: FROM DUAL;
2702:
2703:
2704:
2705: -- Initialize local variable to be used in a decode later in the code,

Line 4706: from dual;

4702: SELECT decode(p_type_class,1,
4703: l_cap_inv_txn_src_literal,
4704: l_inv_txn_src_literal)
4705: INTO l_transaction_source
4706: from dual;
4707:
4708:
4709: END IF; /* check for BP org */
4710:

Line 5706: FROM dual

5702: system_linkage,
5703:
5704: 'P' transaction_status_code,
5705: p_person_type person_type
5706: FROM dual
5707: WHERE p_base_transaction_value <> 0;
5708:
5709: BEGIN
5710: -- initialize local variables

Line 5734: FROM DUAL;

5730:
5731: SELECT 'CC'|| substr( replace( lpad(
5732: to_char(p_Group_Id,'9999999999999'),14,'0') ,' ','0'),-8)
5733: INTO l_batch
5734: FROM DUAL;
5735:
5736: -- get exp ending date for the current transaction's transaction_date
5737: /* Bug 5308514 - Setting the OU context for the current organization */
5738: l_stmt_num := 16;

Line 7111: from dual;

7107: else
7108: l_cost_element_id := -99;
7109: select (decode(sign(l_mmt_primary_quantity),1,10,9))
7110: into l_accounting_line_type
7111: from dual;
7112: End If;
7113: l_mta_primary_quantity:=l_mmt_primary_quantity;
7114: ELSIF ( l_transaction_action_id = 1 AND
7115: l_transaction_source_type_id = 8 ) THEN

Line 7177: FROM DUAL;

7173: 26,31, /* Logical PO receipt for BP org */
7174: 28,1, /* staging Txfrs */
7175: 17, 9, /* Logical Expense Requition Receipt */ -99)
7176: INTO l_accounting_line_type
7177: FROM DUAL;
7178:
7179: IF l_accounting_line_type IN (7,1,14) THEN
7180: l_cost_element_id := NVL(p_cost_element_id,-99);
7181: ELSIF l_accounting_line_type = 2 AND l_transaction_action_id =2 THEN