eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PEOPLE4_PKG dependencies on PER_ALL_PEOPLE_F

Line 133: l_npw_number per_all_people_f.npw_number%type;

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

Line 134: l_party_id per_all_people_f.party_id%type;

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

Line 151: from per_all_people_f

147: );
148: --
149: cursor csr_partyId_details is -- Enh 3299580
150: select party_id
151: from per_all_people_f
152: where person_id = p_person_id
153: and p_session_date between effective_start_date
154: and effective_end_date;
155: --