APPS.GHR_BEN_VALIDATION dependencies on PAY_ELEMENT_TYPES_F

Line 63: l_element_type_id pay_element_types_f.element_type_id%type;

59: p_effective_date date) RETURN BOOLEAN
60: IS
61: l_new_element_name varchar2(250);
62: l_business_group_id per_all_people_f.business_group_id%type;
63: l_element_type_id pay_element_types_f.element_type_id%type;
64: l_exists BOOLEAN;
65:
66: CURSOR c_element_exist(c_assignment_id per_all_assignments_f.assignment_id%type,
67: c_effective_date per_all_assignments_f.effective_start_date%type,

Line 68: c_element_type_id pay_element_types_f.element_type_id%type)

64: l_exists BOOLEAN;
65:
66: CURSOR c_element_exist(c_assignment_id per_all_assignments_f.assignment_id%type,
67: c_effective_date per_all_assignments_f.effective_start_date%type,
68: c_element_type_id pay_element_types_f.element_type_id%type)
69: IS
70: SELECT 1
71: FROM pay_element_entries_f ele
72: WHERE ele.assignment_id = c_assignment_id

Line 76: CURSOR c_element_type_id (c_element_name pay_element_types_f.element_name%type,

72: WHERE ele.assignment_id = c_assignment_id
73: AND c_effective_date BETWEEN ele.effective_start_date AND ele.effective_end_date
74: AND element_type_id = c_element_type_id;
75:
76: CURSOR c_element_type_id (c_element_name pay_element_types_f.element_name%type,
77: c_business_group_id pay_element_links_f.business_group_id%type,
78: c_effective_date per_all_assignments_f.effective_start_date%type)
79: IS
80: SELECT elt.element_type_id

Line 81: FROM pay_element_links eli, pay_element_types_f elt

77: c_business_group_id pay_element_links_f.business_group_id%type,
78: c_effective_date per_all_assignments_f.effective_start_date%type)
79: IS
80: SELECT elt.element_type_id
81: FROM pay_element_links eli, pay_element_types_f elt
82: WHERE elt.element_type_id = eli.element_type_id
83: AND eli.business_group_id = c_business_group_id
84: AND elt.element_name = c_element_name;
85: BEGIN

Line 563: CURSOR c_element(c_element_name pay_element_types_f.element_name%type,

559: ,p_element_type_id in number default null
560: ) IS
561:
562:
563: CURSOR c_element(c_element_name pay_element_types_f.element_name%type,
564: c_assignment_id per_all_assignments_f.assignment_id%type,
565: c_effective_date pay_element_entries_f.effective_start_date%type,
566: c_business_group_id pay_element_links_f.business_group_id%type
567: ) is

Line 578: FROM pay_element_types_f a,

574: e.assignment_id assignment_id,
575: e.object_version_number object_version_number,
576: f.element_entry_value_id element_entry_value_id,
577: f.screen_entry_value screen_entry_value
578: FROM pay_element_types_f a,
579: pay_input_values_f b,
580: pay_element_entries_f e,
581: pay_element_entry_values_f f,
582: pay_element_links_f g

Line 610: FROM pay_element_types_f pet, pay_element_links_f pel

606: CURSOR c_element_name(c_element_link_id pay_element_links_f.element_link_id%type,
607: c_effective_date pay_element_links_f.effective_start_date%type,
608: c_business_group_id pay_element_links_f.business_group_id%type) IS
609: SELECT element_name
610: FROM pay_element_types_f pet, pay_element_links_f pel
611: where pet.element_type_id = pel.element_type_id
612: and c_effective_date between pel.effective_start_date and pel.effective_end_date
613: and pel.business_group_id = c_business_group_id
614: and pel.element_link_id = c_element_link_id;

Line 630: l_new_element_name pay_element_types_f.element_name%type;

626: l_pre_tax_waiver varchar2(20);
627: l_premium_rate varchar2(20);
628: l_per_benefit_info per_people_extra_info%rowtype;
629: l_person_id per_all_people_f.person_id%type;
630: l_new_element_name pay_element_types_f.element_name%type;
631: l_element_name pay_element_types_f.element_name%type;
632: l_ret_plan_name varchar2(200);
633: l_retirement_plan ghr_pa_requests.retirement_plan%type;
634: l_debug_mode BOOLEAN;

Line 631: l_element_name pay_element_types_f.element_name%type;

627: l_premium_rate varchar2(20);
628: l_per_benefit_info per_people_extra_info%rowtype;
629: l_person_id per_all_people_f.person_id%type;
630: l_new_element_name pay_element_types_f.element_name%type;
631: l_element_name pay_element_types_f.element_name%type;
632: l_ret_plan_name varchar2(200);
633: l_retirement_plan ghr_pa_requests.retirement_plan%type;
634: l_debug_mode BOOLEAN;
635: BEGIN