APPS.PAY_GB_RTI_NINO_REPLY_PKG dependencies on PER_ALL_PEOPLE_F

Line 46: l_employee_number per_all_people_f.employee_number%type;

42: e_invalid_paye_ref exception;
43: e_multiple_emp_err exception;
44: l_employer_paye_ref varchar2(35);
45: l_employee_count number := 0;
46: l_employee_number per_all_people_f.employee_number%type;
47: l_date_issued_format varchar(20);
48: l_date_issued varchar2(20);
49: l_date_of_msg_format varchar2(20);
50: l_date_of_msg varchar2(20);

Line 255: per_all_people_f pap where

251: l_datetrack_update_mode varchar2(25);
252: l_future_rec_count number :=0;
253: cursor csr_future_records_count is
254: select count(*) from
255: per_all_people_f pap where
256: pap.person_id = p_person_id
257: and pap.effective_start_date >= p_recent_start_date
258: and pap.effective_start_date > p_date_issued;
259:

Line 263: per_all_people_f pap where

259:
260: -- To fetch the furture records of the employee
261: cursor csr_future_records(c_ignore_date varchar2) is
262: select pap.employee_number,pap.object_version_number, pap.effective_start_date from
263: per_all_people_f pap where
264: pap.person_id = p_person_id
265: and pap.effective_start_date >= p_recent_start_date
266: and pap.effective_start_date > decode(c_ignore_date, 'Y', pap.effective_start_date-1,p_date_issued)
267: order by 3;

Line 470: per_all_people_f pap where

466: ) is
467: cursor csr_emp_details is
468: select pap.person_id,pap.start_date, pap.effective_end_date,
469: pap.employee_number, pap.object_version_number from
470: per_all_people_f pap where
471: pap.business_group_id = p_business_group_id
472: and nvl(pap.national_identifier,'1') = nvl(p_nino_provided,'1')
473: and trim(upper(pap.last_name)) = trim(upper(p_last_name))
474: and trim(upper(pap.first_name)) = trim(upper(p_first_name))