APPS.HR_NL_EXTRA_PERSON_RULES dependencies on PER_PEOPLE_EXTRA_INFO

Line 82: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;

78: l_last_name per_all_people_f.LAST_NAME%TYPE;
79: l_employee_num per_all_people_f.EMPLOYEE_NUMBER%TYPE;
80:
81: l_resend_enabled number := 0;
82: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;
83: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;
84:
85: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS
86: SELECT count(*)

Line 83: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;

79: l_employee_num per_all_people_f.EMPLOYEE_NUMBER%TYPE;
80:
81: l_resend_enabled number := 0;
82: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;
83: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;
84:
85: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS
86: SELECT count(*)
87: FROM PER_PEOPLE_EXTRA_INFO

Line 85: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS

81: l_resend_enabled number := 0;
82: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;
83: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;
84:
85: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS
86: SELECT count(*)
87: FROM PER_PEOPLE_EXTRA_INFO
88: WHERE PERSON_ID = p_csr_person_id
89: AND INFORMATION_TYPE = 'NL_FIRST_DAY_REPORT'

Line 87: FROM PER_PEOPLE_EXTRA_INFO

83: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;
84:
85: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS
86: SELECT count(*)
87: FROM PER_PEOPLE_EXTRA_INFO
88: WHERE PERSON_ID = p_csr_person_id
89: AND INFORMATION_TYPE = 'NL_FIRST_DAY_REPORT'
90: AND PEI_INFORMATION_CATEGORY = 'NL_FIRST_DAY_REPORT'
91: AND upper(pei_information2) = 'Y';

Line 94: CURSOR person_previous_information(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS

90: AND PEI_INFORMATION_CATEGORY = 'NL_FIRST_DAY_REPORT'
91: AND upper(pei_information2) = 'Y';
92:
93:
94: CURSOR person_previous_information(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS
95: SELECT DATE_OF_BIRTH
96: ,PER_INFORMATION1
97: ,PRE_NAME_ADJUNCT
98: ,LAST_NAME

Line 179: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;

175: procedure fdr_rehire_check
176: ( P_PERSON_ID per_all_people_f.person_id%TYPE) IS
177:
178: l_resend_enabled number := 0;
179: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;
180: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;
181:
182: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS
183: SELECT count(*)

Line 180: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;

176: ( P_PERSON_ID per_all_people_f.person_id%TYPE) IS
177:
178: l_resend_enabled number := 0;
179: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;
180: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;
181:
182: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS
183: SELECT count(*)
184: FROM PER_PEOPLE_EXTRA_INFO

Line 182: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS

178: l_resend_enabled number := 0;
179: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;
180: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;
181:
182: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS
183: SELECT count(*)
184: FROM PER_PEOPLE_EXTRA_INFO
185: WHERE PERSON_ID = p_csr_person_id
186: AND INFORMATION_TYPE = 'NL_FIRST_DAY_REPORT'

Line 184: FROM PER_PEOPLE_EXTRA_INFO

180: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;
181:
182: CURSOR resend_enabled(p_csr_person_id PER_PEOPLE_EXTRA_INFO.person_id%TYPE) IS
183: SELECT count(*)
184: FROM PER_PEOPLE_EXTRA_INFO
185: WHERE PERSON_ID = p_csr_person_id
186: AND INFORMATION_TYPE = 'NL_FIRST_DAY_REPORT'
187: AND PEI_INFORMATION_CATEGORY = 'NL_FIRST_DAY_REPORT'
188: AND upper(pei_information2) = 'Y';