DBA Data[Home] [Help]

APPS.IGS_GE_GEN_001 dependencies on IGS_OR_ADDR

Line 552: FROM IGS_OR_ADDR oadv

548: oadv.addr_line_2 oadv_addr_line_2,
549: oadv.addr_line_3 oadv_addr_line_3,
550: oadv.addr_line_4 oadv_addr_line_4,
551: oadv.city oadv_city
552: FROM IGS_OR_ADDR oadv
553: WHERE oadv.org_unit_cd = cp_org_unit_cd AND
554: oadv.correspondence_ind = 'Y';
555:
556: -- cursor for selection of the org_unit address when

Line 568: FROM IGS_OR_ADDR oadv

564: oadv.addr_line_2 oadv_addr_line_2,
565: oadv.addr_line_3 oadv_addr_line_3,
566: oadv.addr_line_4 oadv_addr_line_4,
567: oadv.city oadv_city
568: FROM IGS_OR_ADDR oadv
569: WHERE oadv.org_unit_cd = cp_org_unit_cd AND
570: oadv.addr_type = cp_addr_type;
571:
572: -- Local Variables