DBA Data[Home] [Help]

APPS.IGW_PROP dependencies on IGW_PROP_PERSONS

Line 106: FROM igw_prop_persons pp,

102: BEGIN
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;

Line 131: FROM igw_prop_persons pp,

127: BEGIN
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;

Line 687: INSERT INTO igw_prop_persons

683:
684: PROCEDURE copy_persons
685: ( p_old_proposal_id number, p_new_proposal_id number ) IS
686: BEGIN
687: INSERT INTO igw_prop_persons
688: (
689: proposal_id,
690: person_id,
691: person_party_id,

Line 724: igw_prop_persons

720: SYSDATE,
721: FND_GLOBAL.USER_ID,
722: FND_GLOBAL.LOGIN_ID
723: FROM
724: igw_prop_persons
725: WHERE
726: proposal_id = p_old_proposal_id;
727: EXCEPTION
728: WHEN OTHERS THEN