APPS.PA_CC_BL_PROCESS dependencies on DUAL

Line 35: -- Declaration of individual elements to avoid ORA-3113 error because

31:
32: -- g_org_id stores the current OU.
33: g_org_id pa_implementations_all.org_id%type ;
34:
35: -- Declaration of individual elements to avoid ORA-3113 error because
36: -- FORALL does not allow insert of elements of %rowtype
37:
38: in_acct_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
39: in_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 416: -- Start checking individual EIs

412: END IF;
413:
414:
415: -----------------------------------------------------------
416: -- Start checking individual EIs
417: -----------------------------------------------------------
418:
419: IF P_DEBUG_MODE = 'Y' THEN
420: log_message('reverse_distribution: ' || '250: Checking elements');

Line 1308: ------------------- End of individual item processing ------------

1304: END IF;
1305:
1306: END LOOP; -- Finished processing all input records
1307:
1308: ------------------- End of individual item processing ------------
1309:
1310: IF P_DEBUG_MODE = 'Y' THEN
1311: log_message('reverse_distribution: ' || '2850: Finished processing for ALL input items');
1312: END IF;

Line 1977: FROM dual;

1973: -- be passed to MRC
1974:
1975: SELECT pa_cc_dist_lines_s.nextval
1976: INTO in_cc_dist_line_id(i)
1977: FROM dual;
1978:
1979: in_expenditure_item_id(i) := g_ins_rec(i).expenditure_item_id;
1980: in_line_num(i) := g_ins_rec(i).line_num;
1981: in_acct_currency_code(i) := g_ins_rec(i).acct_currency_code;