APPS.IGW_SPONSOR_ACTION_TBH dependencies on IGW_PROPOSALS_ALL

Line 21: l_sponsor_action_code Igw_Proposals_All.sponsor_action_code%type;

17: WHERE proposal_id = p_proposal_id
18: AND sponsor_action_code IS NOT NULL
19: ORDER BY sponsor_action_date desc, creation_date desc;
20:
21: l_sponsor_action_code Igw_Proposals_All.sponsor_action_code%type;
22: l_sponsor_action_date Igw_Proposals_All.sponsor_action_date%type;
23: l_comments Igw_Proposals_All.sponsor_action_comments%type;
24:
25: BEGIN

Line 22: l_sponsor_action_date Igw_Proposals_All.sponsor_action_date%type;

18: AND sponsor_action_code IS NOT NULL
19: ORDER BY sponsor_action_date desc, creation_date desc;
20:
21: l_sponsor_action_code Igw_Proposals_All.sponsor_action_code%type;
22: l_sponsor_action_date Igw_Proposals_All.sponsor_action_date%type;
23: l_comments Igw_Proposals_All.sponsor_action_comments%type;
24:
25: BEGIN
26:

Line 23: l_comments Igw_Proposals_All.sponsor_action_comments%type;

19: ORDER BY sponsor_action_date desc, creation_date desc;
20:
21: l_sponsor_action_code Igw_Proposals_All.sponsor_action_code%type;
22: l_sponsor_action_date Igw_Proposals_All.sponsor_action_date%type;
23: l_comments Igw_Proposals_All.sponsor_action_comments%type;
24:
25: BEGIN
26:
27: OPEN cur_latest_action;

Line 32: UPDATE igw_proposals_all

28: FETCH cur_latest_action INTO l_sponsor_action_code, l_sponsor_action_date, l_comments;
29:
30: IF cur_latest_action%FOUND THEN
31:
32: UPDATE igw_proposals_all
33: SET sponsor_action_code = l_sponsor_action_code,
34: sponsor_action_date = l_sponsor_action_date,
35: sponsor_action_comments = l_comments
36: WHERE proposal_id = p_proposal_id;