DBA Data[Home] [Help]

APPS.IGS_GE_GEN_002 dependencies on IGS_OR_ADDR

Line 434: FROM IGS_OR_ADDR oadv

430: oadv.addr_line_2 oadv_addr_line_2,
431: oadv.addr_line_3 oadv_addr_line_3,
432: oadv.addr_line_4 oadv_addr_line_4,
433: oadv.city oadv_city
434: FROM IGS_OR_ADDR oadv
435: WHERE oadv.org_unit_cd = cp_org_unit_cd AND
436: oadv.correspondence_ind = 'Y';
437:
438: -- cursor for selection of the IGS_OR_UNIT address when

Line 450: FROM IGS_OR_ADDR oadv

446: oadv.addr_line_2 oadv_addr_line_2,
447: oadv.addr_line_3 oadv_addr_line_3,
448: oadv.addr_line_4 oadv_addr_line_4,
449: oadv.city oadv_city
450: FROM IGS_OR_ADDR oadv
451: WHERE oadv.org_unit_cd = cp_org_unit_cd AND
452: oadv.addr_type = cp_addr_type;
453:
454: -- Local Variables