DBA Data[Home] [Help]

APPS.IGW_PROP dependencies on PER_PEOPLE_X

Line 39: per_people_x p

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:
43: EXCEPTION

Line 107: per_people_x per

103:
104: SELECT full_name
105: INTO v_pi_full_name
106: FROM igw_prop_persons pp,
107: per_people_x per
108: WHERE pp.proposal_id = p_proposal_id
109: AND pp.pi_flag = 'Y'
110: AND per.person_id = pp.person_id;
111:

Line 132: per_people_x per

128:
129: SELECT last_name||','||first_name
130: INTO v_pi_full_name
131: FROM igw_prop_persons pp,
132: per_people_x per
133: WHERE pp.proposal_id = p_proposal_id
134: AND pp.pi_flag = 'Y'
135: AND per.person_id = pp.person_id;
136: