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.PAY_GB_RTI_UPD dependencies on PER_ALL_PEOPLE_F

Line 5: (p_person_id IN per_all_people_f.person_id%TYPE

1: PACKAGE BODY pay_gb_rti_upd AS
2: /* $Header: paygbrtiupd.pkb 120.0.12020000.14 2013/04/04 06:38:35 ssarap noship $ */
3:
4: FUNCTION check_for_active_emp
5: (p_person_id IN per_all_people_f.person_id%TYPE
6: ,p_effective_date IN date) RETURN number IS
7: var number;
8: BEGIN
9: SELECT 1

Line 11: FROM per_all_people_f pap

7: var number;
8: BEGIN
9: SELECT 1
10: INTO var
11: FROM per_all_people_f pap
12: ,per_person_types ppt
13: WHERE p_effective_date BETWEEN pap.effective_start_date
14: AND pap.effective_end_date
15: AND pap.person_id = p_person_id

Line 114: per_all_people_f pap,

110:
111: cursor csr_primary_exists is
112: select paf.assignment_id
113: from
114: per_all_people_f pap,
115: per_all_assignments_f paf
116: where paf.person_id = pap.person_id
117: and paf.person_id = p_person_id
118: and p_effective_date between paf.effective_start_date and paf.effective_end_date

Line 126: per_all_people_f pap,

122:
123: cursor csr_primary_in_curr_paye is
124: select paf.assignment_id
125: from
126: per_all_people_f pap,
127: per_all_assignments_f paf,
128: pay_all_payrolls_f pay,
129: hr_soft_coding_keyflex hsc
130: where paf.person_id = pap.person_id

Line 161: FROM per_all_people_f pap

157: ,trim (pap.per_information9) per_ni_flag
158: ,nvl (paf.primary_flag
159: ,'N') primary_flag
160:
161: FROM per_all_people_f pap
162: ,per_all_assignments_f paf
163: WHERE paf.person_id = pap.person_id
164: AND paf.assignment_id = p_assignment_id
165: AND p_effective_date BETWEEN paf.effective_start_date

Line 192: FROM per_all_people_f pap

188: ,'N') primary_flag
189: INTO v_per_agg_flag
190: ,v_per_ni_flag
191: ,v_primary_flag
192: FROM per_all_people_f pap
193: ,per_all_assignments_f paf
194: WHERE paf.person_id = pap.person_id
195: AND paf.assignment_id = p_assignment_id
196: AND p_effective_date BETWEEN paf.effective_start_date

Line 272: (p_person_id IN per_all_people_f.person_id%TYPE

268: v_status:= false;
269: return v_status;
270: end check_primary_assignment;
271: FUNCTION get_rti_payroll_id
272: (p_person_id IN per_all_people_f.person_id%TYPE
273: ,p_assignment_id IN per_all_assignments_f.assignment_id%type
274: ,p_aggregation_flag IN varchar2
275: ,p_ni_aggregation_flag IN varchar2
276: ,p_effective_date IN date

Line 344: (p_person_id IN per_all_people_f.person_id%TYPE

340:
341: END update_rti_agg_update_asg;
342:
343: PROCEDURE update_rti_agg_new_person
344: (p_person_id IN per_all_people_f.person_id%TYPE
345: ,p_hire_date IN date) IS
346: BEGIN
347: pay_gb_rti_upd.update_rti_agg_person
348: (p_person_id => p_person_id

Line 353: (p_person_id IN per_all_people_f.person_id%TYPE

349: ,p_effective_date => p_hire_date);
350: END update_rti_agg_new_person;
351:
352: PROCEDURE update_rti_agg_person
353: (p_person_id IN per_all_people_f.person_id%TYPE
354: ,p_effective_date IN date) IS
355: CURSOR csr_ni_paye_flag IS
356: SELECT trim (pap.per_information10) per_agg_flag
357: ,trim (pap.per_information9) per_ni_flag

Line 358: FROM per_all_people_f pap

354: ,p_effective_date IN date) IS
355: CURSOR csr_ni_paye_flag IS
356: SELECT trim (pap.per_information10) per_agg_flag
357: ,trim (pap.per_information9) per_ni_flag
358: FROM per_all_people_f pap
359: WHERE pap.person_id = p_person_id
360: AND p_effective_date BETWEEN pap.effective_start_date
361: AND pap.effective_end_date;
362: CURSOR csr_current_person_details IS

Line 370: FROM per_all_people_f pap

366: ,paf.assignment_id assignment_id
367: ,paf.assignment_number assignment_number
368: ,paf.effective_start_date assignment_start_date
369: ,pap.business_group_id business_group_id
370: FROM per_all_people_f pap
371: ,per_all_assignments_f paf
372: WHERE paf.person_id = pap.person_id
373: AND pap.person_id = p_person_id
374: AND p_effective_date BETWEEN pap.effective_start_date

Line 531: FROM per_all_people_f pap

527: AND pay.effective_start_date BETWEEN papf.effective_start_date
528: AND papf.effective_end_date)),'[]\#^}{_.@\[\$]','') primary_assignment_number
529:
530: ,pap.employee_number
531: FROM per_all_people_f pap
532: ,per_all_assignments_f asg
533: ,per_assignment_status_types past
534: --,per_periods_of_service serv
535: ,pay_all_payrolls_f pay

Line 556: FROM per_all_people_f papf2

552: and pay.effective_end_date
553: /*AND pap.effective_start_date =
554: (
555: SELECT MAX(papf2.effective_start_date)
556: FROM per_all_people_f papf2
557: WHERE papf2.person_id = pap.person_id
558: )
559: AND asg.effective_start_date =
560: (

Line 602: l_prev_emp_number per_all_people_f.employee_number%type;

598: l_rti_payroll_id varchar2(30);
599: l_count_processed number;
600: l_err_employee ERR_EMPLOYEE;
601: l_err_count NUMBER;
602: l_prev_emp_number per_all_people_f.employee_number%type;
603: l_pre_emp_length number;
604: l_curr_emp_length number;
605: l_proc CONSTANT varchar2(30) := 'PY_GB_RTI_PAYROLL_UPDT';
606: l_total_count NUMBER;