APPS.QP_BULK_UTIL dependencies on DUAL

Line 483: FROM DUAL

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

Line 751: FROM DUAL

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

Line 1145: FROM DUAL

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