APPS.GHR_VALIDATE_CHECK dependencies on PAY_ELEMENT_TYPES_F

Line 223: from pay_element_types_f elt,

219:
220:
221: CURSOR check_for_supervisory IS
222: select eev.screen_entry_value
223: from pay_element_types_f elt,
224: pay_input_values_f ipv,
225: pay_element_entries_f ele,
226: pay_element_entry_values_f eev
227: where trunc(p_pa_request_rec.effective_date) between elt.effective_start_date

Line 385: p_ele_name pay_element_types_f.element_name%type,

381: l_repay_sch varchar2(2);
382: l_review_date date;
383:
384: CURSOR cur_studloan_ele_end_date(
385: p_ele_name pay_element_types_f.element_name%type,
386: p_asg_id ghr_pa_requests.employee_assignment_id%type)
387: IS
388: select ele.effective_end_date
389: from pay_element_types_f elt,

Line 389: from pay_element_types_f elt,

385: p_ele_name pay_element_types_f.element_name%type,
386: p_asg_id ghr_pa_requests.employee_assignment_id%type)
387: IS
388: select ele.effective_end_date
389: from pay_element_types_f elt,
390: pay_element_links_f ell,
391: pay_element_entries_f ele
392: where p_pa_request_rec.effective_date between elt.effective_start_date and elt.effective_end_date
393: and p_pa_request_rec.effective_date between ell.effective_start_date and ell.effective_end_date

Line 406: FROM pay_element_types_f

402:
403: SELECT effective_end_date
404: FROM pay_element_entries_f
405: WHERE element_type_id = (SELECT element_type_id
406: FROM pay_element_types_f
407: WHERE element_name = p_ele_name
408: and p_pa_request_rec.effective_date between effective_start_Date and effective_end_date )
409: and assignment_id = p_asg_id;
410: ****/

Line 426: l_ele_name pay_element_types_f.element_name%type;

422: AND grd.grade_definition_id = gdf.grade_definition_id;
423: --End of 3604377
424:
425: l_appt_type PER_PEOPLE_EXTRA_INFO.pei_information3%type;
426: l_ele_name pay_element_types_f.element_name%type;
427: l_ele_end_date pay_element_entries_f.effective_end_date%type;
428:
429: l_per_ei_data PER_PEOPLE_EXTRA_INFO%rowtype;
430: -- Bug#3928110

Line 499: FROM pay_element_entries_f ee, pay_element_types_f et

495:
496: -- Bug#5041985
497: CURSOR c_futr_incentives(l_asg_id NUMBER, l_effective_date DATE) IS
498: SELECT count(*) cnt
499: FROM pay_element_entries_f ee, pay_element_types_f et
500: WHERE ee.assignment_id = l_asg_id
501: AND ee.element_type_id = et.element_type_id
502: AND et.element_name like '%Incentive%'
503: AND ee.effective_start_date > l_effective_date;

Line 2601: FROM pay_element_types_f elt

2597: p_bg_id IN NUMBER)
2598: IS
2599: SELECT eev.screen_entry_value
2600: ,eev.effective_start_date
2601: FROM pay_element_types_f elt
2602: ,pay_input_values_f ipv
2603: ,pay_element_entries_f ele
2604: ,pay_element_entry_values_f eev
2605: WHERE p_effective_date < eev.effective_start_date