APPS.GMF_GLSYNCH dependencies on DUAL

Line 768: SELECT GEM5_address_id_s.nextval INTO pi_addr_id FROM dual;

764: addr_id = pi_addr_id;
765: END IF;
766:
767: IF SQL%NOTFOUND OR pi_addr_id = 0 or pi_addr_id is NULL THEN
768: SELECT GEM5_address_id_s.nextval INTO pi_addr_id FROM dual;
769: INSERT into sy_addr_mst(
770: addr_id,
771: addr1,
772: addr2,

Line 832: FROM SYS.DUAL

828: nvl(pi_date_added, to_date(2440588,'J')),
829: nvl(pi_added_by,0),
830: nvl(pi_date_modified, to_date(2440588,'J')),
831: nvl(pi_modified_by,0)
832: FROM SYS.DUAL
833: WHERE not exists(
834: SELECT 1 FROM SY_GEOG_MST
835: WHERE geog_type = 2 and geog_code = pi_state_code);
836: END IF;