APPS.GMF_GLSYNCH dependencies on SY_ADDR_MST

Line 746: UPDATE sy_addr_mst

742: pi_date_added in varchar2,
743: pi_added_by in varchar2) IS
744: BEGIN
745: IF pi_addr_id <> 0 and pi_addr_id is not null THEN
746: UPDATE sy_addr_mst
747: SET
748: addr1 = nvl(pi_addr1,' '),
749: addr2 = nvl(pi_addr2,' '),
750: addr3 = nvl(pi_addr3,' '),

Line 769: INSERT into sy_addr_mst(

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,
773: addr3,