APPS.GHR_ELT_TO_BEN_PKG dependencies on PER_ALL_PEOPLE_F

Line 25: FROM per_all_people_f a,hr_organization_information hoi

21:
22: -- Cursor to fetch distinct person records.
23: CURSOR c_per_records IS
24: SELECT distinct a.person_id person_id
25: FROM per_all_people_f a,hr_organization_information hoi
26: WHERE a.business_group_id = hoi.organization_id
27: AND hoi.org_information_context = 'GHR_US_ORG_INFORMATION';
28:
29: -- Cursor to find total number of distinct person records

Line 32: FROM per_all_people_f a,hr_organization_information hoi

28:
29: -- Cursor to find total number of distinct person records
30: CURSOR c_tot_per_records IS
31: SELECT COUNT(distinct a.person_id) person_count
32: FROM per_all_people_f a,hr_organization_information hoi
33: WHERE a.business_group_id = hoi.organization_id
34: AND hoi.org_information_context = 'GHR_US_ORG_INFORMATION';
35:
36: CURSOR c_completion_status(c_session_id NUMBER) IS

Line 233: l_ssn per_all_people_f.national_identifier%TYPE;

229: l_errbuf VARCHAR2(2000);
230: l_retcode NUMBER;
231:
232: l_per_err_cnt NUMBER(15);
233: l_ssn per_all_people_f.national_identifier%TYPE;
234: l_full_name per_all_people_f.full_name%TYPE;
235: l_dummy VARCHAR2(1);
236: l_sid NUMBER;
237: -- ****** MAIN Program CURSORS *********

Line 234: l_full_name per_all_people_f.full_name%TYPE;

230: l_retcode NUMBER;
231:
232: l_per_err_cnt NUMBER(15);
233: l_ssn per_all_people_f.national_identifier%TYPE;
234: l_full_name per_all_people_f.full_name%TYPE;
235: l_dummy VARCHAR2(1);
236: l_sid NUMBER;
237: -- ****** MAIN Program CURSORS *********
238: -- Cursor to verify whether Person benefits EIT is created or not

Line 310: FROM per_all_people_f per

306: ) IS
307: CURSOR cur_per IS
308: SELECT per.full_name
309: ,per.national_identifier
310: FROM per_all_people_f per
311: WHERE per.person_id = p_person_id
312: AND NVL(p_effective_date,TRUNC(sysdate)) between per.effective_start_date
313: and per.effective_end_date;
314: BEGIN

Line 632: l_ssn per_all_people_f.national_identifier%TYPE;

628: p_business_group_id in Number) is
629:
630: l_assignment_id pay_element_entries_f.assignment_id%type;
631: l_req VARCHAR2 (25);
632: l_ssn per_all_people_f.national_identifier%TYPE;
633: l_program_name ghr_process_log.program_name%TYPE;
634: cursor cur_business_group is
635: select business_group_id from per_assignments_f
636: where assignment_id = l_assignment_id;