APPS.GHR_VALIDATE_CHECK dependencies on PAY_ELEMENT_ENTRIES_F

Line 225: pay_element_entries_f ele,

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
228: and elt.effective_end_date
229: and trunc(p_pa_request_rec.effective_date) between ipv.effective_start_date

Line 391: pay_element_entries_f ele

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
394: and p_pa_request_rec.effective_date between ele.effective_start_date and ele.effective_end_date
395: and elt.element_type_id = ell.element_type_id

Line 401: in pay_element_entries_f.

397: and ele.assignment_id = p_asg_id
398: and elt.element_name = p_ele_name;
399:
400: /**** Commented because FP.F level DB is not having the element_type_id column
401: in pay_element_entries_f.
402:
403: SELECT effective_end_date
404: FROM pay_element_entries_f
405: WHERE element_type_id = (SELECT element_type_id

Line 404: FROM pay_element_entries_f

400: /**** Commented because FP.F level DB is not having the element_type_id column
401: in pay_element_entries_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 )

Line 427: l_ele_end_date pay_element_entries_f.effective_end_date%type;

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
431: --l_percent NUMBER(8,2);

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 2603: ,pay_element_entries_f ele

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
2606: AND eev.effective_end_date IS NULL
2607: AND elt.element_type_id = ipv.element_type_id