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

Line 173: FROM per_all_people_f per

169: ,p_effective_date IN DATE
170: ,p_sex OUT NOCOPY VARCHAR2) IS
171: CURSOR cur_per_sex IS
172: SELECT per.sex
173: FROM per_all_people_f per
174: WHERE per.person_id = p_person_id
175: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date;
176: BEGIN
177: FOR cur_per_sex_rec IN cur_per_sex LOOP

Line 1265: CURSOR cur_per_details(p_person_id per_all_people_f.person_id%type)

1261: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
1262: -- End Bug 4542476
1263:
1264:
1265: CURSOR cur_per_details(p_person_id per_all_people_f.person_id%type)
1266: IS
1267: SELECT title,last_name
1268: FROM per_all_people_f
1269: WHERE person_id = p_person_id;

Line 1268: FROM per_all_people_f

1264:
1265: CURSOR cur_per_details(p_person_id per_all_people_f.person_id%type)
1266: IS
1267: SELECT title,last_name
1268: FROM per_all_people_f
1269: WHERE person_id = p_person_id;
1270:
1271: CURSOR cur_scd_dates(p_pa_request_id ghr_pa_requests.pa_request_id%type)
1272: IS

Line 1300: l_last_name per_all_people_f.last_name%type;

1296: l_mesgbuff1 VARCHAR2(4000);
1297: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
1298: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;
1299: ll_per_ei_data per_people_extra_info%rowtype;
1300: l_last_name per_all_people_f.last_name%type;
1301: l_suffix per_all_people_f.title%type;
1302:
1303: -- For Dual Actions PRD is becoming null so preserving it using a local variable.
1304: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;

Line 1301: l_suffix per_all_people_f.title%type;

1297: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
1298: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;
1299: ll_per_ei_data per_people_extra_info%rowtype;
1300: l_last_name per_all_people_f.last_name%type;
1301: l_suffix per_all_people_f.title%type;
1302:
1303: -- For Dual Actions PRD is becoming null so preserving it using a local variable.
1304: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1305: