APPS.PER_PEOPLE4_PKG dependencies on PER_ALL_PEOPLE_F

Line 129: l_npw_number per_all_people_f.npw_number%type;

125: l_num_appls NUMBER; -- Number of applicants.
126: l_num_accepted_appls NUMBER; -- Number of accepted spplicant assignments
127: l_set_of_books_id NUMBER; -- Required for GL.
128: v_dummy NUMBER; -- For cursor fetch.
129: l_npw_number per_all_people_f.npw_number%type;
130: l_party_id per_all_people_f.party_id%type;
131: --
132: cursor get_pay_proposal
133: is

Line 130: l_party_id per_all_people_f.party_id%type;

126: l_num_accepted_appls NUMBER; -- Number of accepted spplicant assignments
127: l_set_of_books_id NUMBER; -- Required for GL.
128: v_dummy NUMBER; -- For cursor fetch.
129: l_npw_number per_all_people_f.npw_number%type;
130: l_party_id per_all_people_f.party_id%type;
131: --
132: cursor get_pay_proposal
133: is
134: select PAY_PROPOSAL_ID

Line 147: from per_all_people_f

143: );
144: --
145: cursor csr_partyId_details is -- Enh 3299580
146: select party_id
147: from per_all_people_f
148: where person_id = p_person_id
149: and p_session_date between effective_start_date
150: and effective_end_date;
151: begin