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_BEN_VALIDATION dependencies on PAY_ELEMENT_LINKS_F

Line 110: c_business_group_id pay_element_links_f.business_group_id%type,

106: AND c_effective_date BETWEEN ele.effective_start_date AND ele.effective_end_date
107: AND element_type_id = c_element_type_id;
108:
109: CURSOR c_element_type_id (c_element_name pay_element_types_f.element_name%type,
110: c_business_group_id pay_element_links_f.business_group_id%type,
111: c_effective_date per_all_assignments_f.effective_start_date%type)
112: IS
113: SELECT elt.element_type_id
114: FROM pay_element_links eli, pay_element_types_f elt

Line 770: c_business_group_id pay_element_links_f.business_group_id%type

766: --Bug #12553476 Modified c_element cursor to map the effective date comparison
767: CURSOR c_element(c_element_name pay_element_types_f.element_name%type,
768: c_assignment_id per_all_assignments_f.assignment_id%type,
769: c_effective_date pay_element_entries_f.effective_start_date%type,
770: c_business_group_id pay_element_links_f.business_group_id%type
771: ) is
772: SELECT a.element_name element_name,
773: b.name ipv_name,
774: f.input_value_id input_value_id,

Line 786: pay_element_links_f g

782: FROM pay_element_types_f a,
783: pay_input_values_f b,
784: pay_element_entries_f e,
785: pay_element_entry_values_f f,
786: pay_element_links_f g
787: WHERE a.element_type_id = b.element_type_id
788: AND e.element_type_id = a.element_type_id
789: AND f.element_entry_id = e.element_entry_id
790: AND f.input_value_id = b.input_value_id

Line 811: CURSOR c_element_name(c_element_link_id pay_element_links_f.element_link_id%type,

807: FROM per_all_assignments_f asg
808: WHERE asg.assignment_id = c_assignment_id
809: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
810:
811: CURSOR c_element_name(c_element_link_id pay_element_links_f.element_link_id%type,
812: c_effective_date pay_element_links_f.effective_start_date%type,
813: c_business_group_id pay_element_links_f.business_group_id%type) IS
814: SELECT element_name
815: FROM pay_element_types_f pet, pay_element_links_f pel

Line 812: c_effective_date pay_element_links_f.effective_start_date%type,

808: WHERE asg.assignment_id = c_assignment_id
809: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
810:
811: CURSOR c_element_name(c_element_link_id pay_element_links_f.element_link_id%type,
812: c_effective_date pay_element_links_f.effective_start_date%type,
813: c_business_group_id pay_element_links_f.business_group_id%type) IS
814: SELECT element_name
815: FROM pay_element_types_f pet, pay_element_links_f pel
816: where pet.element_type_id = pel.element_type_id

Line 813: c_business_group_id pay_element_links_f.business_group_id%type) IS

809: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
810:
811: CURSOR c_element_name(c_element_link_id pay_element_links_f.element_link_id%type,
812: c_effective_date pay_element_links_f.effective_start_date%type,
813: c_business_group_id pay_element_links_f.business_group_id%type) IS
814: SELECT element_name
815: FROM pay_element_types_f pet, pay_element_links_f pel
816: where pet.element_type_id = pel.element_type_id
817: and c_effective_date between pel.effective_start_date and pel.effective_end_date

Line 815: FROM pay_element_types_f pet, pay_element_links_f pel

811: CURSOR c_element_name(c_element_link_id pay_element_links_f.element_link_id%type,
812: c_effective_date pay_element_links_f.effective_start_date%type,
813: c_business_group_id pay_element_links_f.business_group_id%type) IS
814: SELECT element_name
815: FROM pay_element_types_f pet, pay_element_links_f pel
816: where pet.element_type_id = pel.element_type_id
817: and c_effective_date between pel.effective_start_date and pel.effective_end_date
818: and pel.business_group_id = c_business_group_id
819: and pel.element_link_id = c_element_link_id;

Line 855: pay_element_links_f eli,

851: IS
852: select ele.element_entry_id,
853: ele.object_version_number
854: from pay_element_types_f elt,
855: pay_element_links_f eli,
856: pay_element_entries_f ele
857: where ele.assignment_id = p_assignment_id
858: and upper(elt.element_name) = upper('TSP Roth 401K')
859: and elt.element_type_id = eli.element_type_id + 0