APPS.CST_PRJMFG_COST_COLLECTOR dependencies on DUAL

Line 633: FROM dual;

629: l_stmt_num := 10;
630:
631: SELECT mtl_material_transactions_s.nextval
632: INTO p_group_id
633: FROM dual;
634:
635: l_stmt_num := 20;
636:
637: FOR sel_mmt_rec IN sel_mmt_trx( p_Org_Id,

Line 1245: FROM dual;

1241: l_stmt_num := 10;
1242:
1243: SELECT wip_transactions_S.nextval
1244: INTO l_group_id
1245: FROM dual;
1246:
1247: p_group_id := l_group_id;
1248: l_stmt_num := 20;
1249:

Line 1526: FROM DUAL;

1522: 4, 4, --RES ABSO;OSP
1523: 5, 3, --OVHD ABSO
1524: 4))
1525: INTO l_accounting_line_type
1526: FROM DUAL;
1527:
1528: l_stmt_num := 14;
1529:
1530: /* Bug 2599649

Line 2640: FROM DUAL;

2636:
2637: SELECT 'CC'|| substr( replace( lpad(
2638: to_char(p_Group_Id,'9999999999999'),14,'0') ,' ','0'),-8)
2639: INTO l_batch
2640: FROM DUAL;
2641:
2642:
2643:
2644: -- Initialize local variable to be used in a decode later in the code,

Line 4645: from dual;

4641: SELECT decode(p_type_class,1,
4642: l_cap_inv_txn_src_literal,
4643: l_inv_txn_src_literal)
4644: INTO l_transaction_source
4645: from dual;
4646:
4647:
4648: END IF; /* check for BP org */
4649:

Line 5639: FROM dual

5635: system_linkage,
5636:
5637: 'P' transaction_status_code
5638:
5639: FROM dual
5640: WHERE p_base_transaction_value <> 0;
5641:
5642: BEGIN
5643: -- initialize local variables

Line 5667: FROM DUAL;

5663:
5664: SELECT 'CC'|| substr( replace( lpad(
5665: to_char(p_Group_Id,'9999999999999'),14,'0') ,' ','0'),-8)
5666: INTO l_batch
5667: FROM DUAL;
5668:
5669: -- get exp ending date for the current transaction's transaction_date
5670: /* Bug 5308514 - Setting the OU context for the current organization */
5671: l_stmt_num := 16;

Line 6891: from dual;

6887: else
6888: l_cost_element_id := -99;
6889: select (decode(sign(l_mmt_primary_quantity),1,10,9))
6890: into l_accounting_line_type
6891: from dual;
6892: End If;
6893: l_mta_primary_quantity:=l_mmt_primary_quantity;
6894: ELSIF ( l_transaction_action_id = 1 AND
6895: l_transaction_source_type_id = 8 ) THEN

Line 6957: FROM DUAL;

6953: 26,31, /* Logical PO receipt for BP org */
6954: 28,1, /* staging Txfrs */
6955: 17, 9, /* Logical Expense Requition Receipt */ -99)
6956: INTO l_accounting_line_type
6957: FROM DUAL;
6958:
6959: IF l_accounting_line_type IN (7,1,14) THEN
6960: l_cost_element_id := NVL(p_cost_element_id,-99);
6961: ELSIF l_accounting_line_type = 2 AND l_transaction_action_id =2 THEN