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 329: p_ele_name pay_element_types_f.element_name%type,

325: l_repay_sch varchar2(2);
326: l_review_date date;
327:
328: CURSOR cur_studloan_ele_end_date(
329: p_ele_name pay_element_types_f.element_name%type,
330: p_asg_id ghr_pa_requests.employee_assignment_id%type)
331: IS
332: select ele.effective_end_date
333: from pay_element_types_f elt,

Line 333: from pay_element_types_f elt,

329: p_ele_name pay_element_types_f.element_name%type,
330: p_asg_id ghr_pa_requests.employee_assignment_id%type)
331: IS
332: select ele.effective_end_date
333: from pay_element_types_f elt,
334: pay_element_links_f ell,
335: pay_element_entries_f ele
336: where p_pa_request_rec.effective_date between elt.effective_start_date and elt.effective_end_date
337: and p_pa_request_rec.effective_date between ell.effective_start_date and ell.effective_end_date

Line 350: FROM pay_element_types_f

346:
347: SELECT effective_end_date
348: FROM pay_element_entries_f
349: WHERE element_type_id = (SELECT element_type_id
350: FROM pay_element_types_f
351: WHERE element_name = p_ele_name
352: and p_pa_request_rec.effective_date between effective_start_Date and effective_end_date )
353: and assignment_id = p_asg_id;
354: ****/

Line 370: l_ele_name pay_element_types_f.element_name%type;

366: AND grd.grade_definition_id = gdf.grade_definition_id;
367: --End of 3604377
368:
369: l_appt_type PER_PEOPLE_EXTRA_INFO.pei_information3%type;
370: l_ele_name pay_element_types_f.element_name%type;
371: l_ele_end_date pay_element_entries_f.effective_end_date%type;
372:
373: l_per_ei_data PER_PEOPLE_EXTRA_INFO%rowtype;
374: -- Bug#3928110

Line 443: FROM pay_element_entries_f ee, pay_element_types_f et

439:
440: -- Bug#5041985
441: CURSOR c_futr_incentives(l_asg_id NUMBER, l_effective_date DATE) IS
442: SELECT count(*) cnt
443: FROM pay_element_entries_f ee, pay_element_types_f et
444: WHERE ee.assignment_id = l_asg_id
445: AND ee.element_type_id = et.element_type_id
446: AND et.element_name like '%Incentive%'
447: AND ee.effective_start_date > l_effective_date;

Line 2301: FROM pay_element_types_f elt

2297: p_bg_id IN NUMBER)
2298: IS
2299: SELECT eev.screen_entry_value
2300: ,eev.effective_start_date
2301: FROM pay_element_types_f elt
2302: ,pay_input_values_f ipv
2303: ,pay_element_entries_f ele
2304: ,pay_element_entry_values_f eev
2305: WHERE p_effective_date < eev.effective_start_date