APPS.QP_BULK_UTIL dependencies on DUAL

Line 482: FROM DUAL

478: --added for MOAC
479: ,P_HEADER_REC.ORIG_ORG_ID(I)
480: -- ,P_HEADER_REC.ORIG_ORG_ID(I)
481: ,P_HEADER_REC.GLOBAL_FLAG(I)
482: FROM DUAL
483: WHERE P_HEADER_REC.process_status_flag(I) IS NOT NULL;
484:
485:
486: qp_bulk_loader_pub.write_log('Inserted Header records: '|| SQL%ROWCOUNT);

Line 750: FROM DUAL

746: --Bug#5359974 RAVI
747: ,P_LINE_REC.CONTINUOUS_PRICE_BREAK_FLAG(I)
748: --);
749: --6028305
750: FROM DUAL
751: WHERE exists
752: (Select 'Y' from qp_interface_list_lines
753: WHERE orig_sys_line_ref=P_LINE_REC.ORIG_SYS_LINE_REF(I)
754: AND request_id=P_LINE_REC.REQUEST_ID(I)

Line 1144: FROM DUAL

1140: ,P_PRICING_ATTR_REC.ORIG_SYS_HEADER_REF(I)
1141: ,P_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF(I)
1142: --);
1143: --6028305
1144: FROM DUAL
1145: WHERE exists (SELECT 'Y' from qp_interface_pricing_Attribs
1146: WHERE ORIG_SYS_PRICING_ATTR_REF=P_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF(I)
1147: AND request_id=P_PRICING_ATTR_REC.REQUEST_ID(I)
1148: AND process_status_flag is not null);