DBA Data[Home] [Help]

APPS.PA_FORECASTITEM_PVT dependencies on DUAL

Line 1531: FROM DUAL

1527:
1528: BEGIN
1529: SELECT 'Y'
1530: INTO lv_exist_flag
1531: FROM DUAL
1532: WHERE EXISTS (SELECT NULL
1533: FROM pa_forecast_items
1534: WHERE assignment_id = p_assignment_id
1535: AND delete_flag = 'N');

Line 5806: FROM dual

5802:
5803: BEGIN
5804: SELECT 'Y'
5805: INTO lv_exist_flag
5806: FROM dual
5807: WHERE exists (SELECT null
5808: FROM pa_forecast_items
5809: WHERE assignment_id = p_assignment_id
5810: AND delete_flag = 'N');

Line 15233: from dual;

15229: lt_FIHdrInsTab(li_hdr_ins_count) := lt_SourceFIHdrTab(li_counter_source_hdr);
15230:
15231: select pa_forecast_items_s.NEXTVAL
15232: into li_new_forecast_item_id
15233: from dual;
15234:
15235: lt_FIHdrInsTab(li_hdr_ins_count).forecast_item_id := li_new_forecast_item_id;
15236: lt_FIHdrInsTab(li_hdr_ins_count).assignment_id := p_requirement_id_tbl(l_counter).assignment_id;
15237: