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 77: c_business_group_id pay_element_links_f.business_group_id%type,

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
81: FROM pay_element_links eli, pay_element_types_f elt

Line 566: c_business_group_id pay_element_links_f.business_group_id%type

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
568: SELECT a.element_name element_name,
569: b.name ipv_name,
570: f.input_value_id input_value_id,

Line 582: pay_element_links_f g

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
583: WHERE a.element_type_id = b.element_type_id
584: AND e.element_type_id = a.element_type_id
585: AND f.element_entry_id = e.element_entry_id
586: AND f.input_value_id = b.input_value_id

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

602: FROM per_all_assignments_f asg
603: WHERE asg.assignment_id = c_assignment_id
604: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
605:
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

Line 607: c_effective_date pay_element_links_f.effective_start_date%type,

603: WHERE asg.assignment_id = c_assignment_id
604: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
605:
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

Line 608: c_business_group_id pay_element_links_f.business_group_id%type) IS

604: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
605:
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

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;