APPS.PA_PLAN_MATRIX dependencies on DUAL

Line 586: from dual;

582: IF SQL%ROWCOUNT = 0 THEN
583:
584: select pa_budget_lines_s.nextval
585: into l_budget_line_id
586: from dual;
587:
588: INSERT INTO PA_BUDGET_LINES
589: (budget_line_id, /* FPB2 */
590: budget_version_id, /* FPB2 */

Line 886: from dual;

882: ELSE
883: /*IF SQL%ROWCOUNT = 0 THEN*/
884: select pa_budget_lines_s.nextval
885: into l_budget_line_id
886: from dual;
887:
888: INSERT INTO PA_BUDGET_LINES
889: (Budget_Line_id, /* FPB2 */
890: Budget_Version_id, /* FPB2 */

Line 3402: INTO l_parent_assign_id_local from DUAL;

3398: Currency_Code = l_currency_code;
3399: IF SQL%ROWCOUNT = 0 THEN
3400: -- Get the value for parent assignment id through the decode function
3401: SELECT DECODE(l_parent_assign_id, NULL, l_parent_assignment_id, l_parent_assign_id)
3402: INTO l_parent_assign_id_local from DUAL;
3403:
3404: l_prev_amt_tab(l_matrix_counter) := l_prev_amt;
3405: l_next_amt_tab(l_matrix_counter) := l_next_amt;
3406: l_prior_amt_tab(l_matrix_counter):= l_prior_amt;