APPS.IGW_PROP dependencies on IGW_ORG_DETAILS

Line 38: FROM igw_org_details o,

34: SELECT o.signing_official_id,
35: p.full_name
36: INTO o_signing_official_id,
37: o_signing_official_name
38: FROM igw_org_details o,
39: per_people_x p
40: WHERE o.organization_id = i_organization_id
41: AND p.person_id = o.signing_official_id;
42:

Line 59: FROM igw_org_details

55: v_admin_official_id number(15);
56:
57: CURSOR cur_org_details IS
58: SELECT admin_official_id
59: FROM igw_org_details
60: WHERE organization_id = i_organization_id;
61:
62: BEGIN
63:

Line 218: igw_org_details o

214:
215: SELECT l.meaning
216: INTO v_major_subdivision
217: FROM fnd_lookups l,
218: igw_org_details o
219: WHERE o.organization_id = p_organization_id
220: AND l.lookup_type = 'IGW_NIH_MAJOR_SUBDIVISION'
221: AND l.lookup_code = o.nih_subdivision_code;
222: