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_ELEMENT_API dependencies on PAY_ELEMENT_TYPES_F

Line 52: (p_element_name in pay_element_types_f.element_name%type

48: -- The FETCH_ELEMENT_INFO_COR (history package) is being sent p_element_name
49: -- (old_element_name) as it has calls to return_new_element_name already.
50: --
51: procedure retrieve_element_info
52: (p_element_name in pay_element_types_f.element_name%type
53: ,p_input_value_name in pay_input_values_f.name%type
54: ,p_assignment_id in pay_element_entries_f.assignment_id%type
55: ,p_effective_date in date
56: ,p_processing_type in pay_element_types_f.processing_type%type

Line 56: ,p_processing_type in pay_element_types_f.processing_type%type

52: (p_element_name in pay_element_types_f.element_name%type
53: ,p_input_value_name in pay_input_values_f.name%type
54: ,p_assignment_id in pay_element_entries_f.assignment_id%type
55: ,p_effective_date in date
56: ,p_processing_type in pay_element_types_f.processing_type%type
57: ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type
58: ,p_input_value_id out nocopy pay_input_values_f.input_value_id%type
59: ,p_element_entry_id out nocopy pay_element_entries_f.element_entry_id%type
60: ,p_value out nocopy pay_element_entry_values_f.screen_entry_value%type

Line 85: from pay_element_types_f elt,

81: eli.element_link_id,
82: ele.element_entry_id,
83: eev.screen_entry_value screen_entry_value,
84: ele.object_version_number
85: from pay_element_types_f elt,
86: pay_input_values_f ipv,
87: pay_element_links_f eli,
88: pay_element_entries_f ele,
89: pay_element_entry_values_f eev

Line 123: from pay_element_types_f elt,

119: eli.element_link_id,
120: ele.element_entry_id,
121: eev.screen_entry_value screen_entry_value,
122: ele.object_version_number
123: from pay_element_types_f elt,
124: pay_input_values_f ipv,
125: pay_element_links_f eli,
126: pay_element_entries_f ele,
127: pay_element_entry_values_f eev

Line 166: from pay_element_types_f elt,

162: eli.element_link_id,
163: ele.element_entry_id,
164: eev.screen_entry_value screen_entry_value,
165: ele.object_version_number
166: from pay_element_types_f elt,
167: pay_input_values_f ipv,
168: pay_element_links_f eli,
169: pay_element_entries_f ele,
170: pay_element_entry_values_f eev

Line 558: (p_element_name in pay_element_types_f.element_name%type

554: --
555: -- {End of Comments}
556: -- ---------------------------------------------------------------------------
557: function get_input_value_id
558: (p_element_name in pay_element_types_f.element_name%type
559: ,p_input_value_name in pay_input_values_f.name%type
560: ,p_effective_date in date
561: ) return pay_input_values_f.input_value_id%type is
562: --

Line 570: from pay_element_types_f elt,

566: ,input_name in varchar2
567: ,eff_date in date
568: ,bg_id in NUMBER) is
569: select ipv.input_value_id
570: from pay_element_types_f elt,
571: pay_input_values_f ipv
572: where trunc(eff_date) between elt.effective_start_date
573: and elt.effective_end_date
574: and trunc(eff_date) between ipv.effective_start_date

Line 699: ,p_element_name in pay_element_types_f.element_name%type

695: -- ---------------------------------------------------------------------------
696: --
697: procedure process_sf52_element
698: (p_assignment_id in per_assignments_f.assignment_id%type
699: ,p_element_name in pay_element_types_f.element_name%type
700: ,p_input_value_name1 in pay_input_values_f.name%type
701: default null
702: ,p_value1 in pay_element_entry_values_f.screen_entry_value%type
703: default null

Line 766: l_element_type_id pay_element_types_f.element_type_id%type;

762: ) is
763: --
764: l_proc varchar2(72) := g_package||'process_sf52_element';
765: l_business_group_id per_business_groups.business_group_id%type;
766: l_element_type_id pay_element_types_f.element_type_id%type;
767: l_element_link_id pay_element_links_f.element_link_id%type;
768: l_entry_type pay_element_entries_f.entry_type%type default 'E';
769: l_input_value_id1 pay_input_values_f.input_value_id%type;
770: l_input_value_id2 pay_input_values_f.input_value_id%type;

Line 801: l_processing_type pay_element_types_f.processing_type%type;

797: l_value14 pay_element_entry_values_f.screen_entry_value%type;
798: l_value15 pay_element_entry_values_f.screen_entry_value%type;
799: l_effective_start_date date;
800: l_effective_end_date date;
801: l_processing_type pay_element_types_f.processing_type%type;
802: l_element_entry_id pay_element_entries_f.element_entry_id%type;
803: l_element_entry_id1 pay_element_entries_f.element_entry_id%type;
804: l_object_version_number pay_element_entries_f.object_version_number%type;
805: l_object_version_number1 pay_element_entries_f.object_version_number%type;

Line 835: from pay_element_types_f elt

831: ,ele_name in varchar2
832: ,eff_date in date) is
833: select elt.element_type_id,
834: elt.processing_type
835: from pay_element_types_f elt
836: where trunc(eff_date) between elt.effective_start_date
837: and elt.effective_end_date
838: and upper(elt.element_name) = upper(ele_name)
839: and ( elt.business_group_id is NULL or

Line 860: FROM pay_element_entries_f ee, pay_element_types_f et

856: --
857: -- Bug#5045806
858: CURSOR c_curr_incentive(l_asg_id NUMBER, l_effective_date DATE, l_element_name VARCHAR2) IS
859: SELECT count(*) cnt
860: FROM pay_element_entries_f ee, pay_element_types_f et
861: WHERE ee.assignment_id = l_asg_id
862: AND ee.element_type_id = et.element_type_id
863: AND et.element_name = l_element_name
864: AND l_effective_date between ee.effective_start_date