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 168: from pay_element_types_f elt,

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

Line 560: (p_element_name in pay_element_types_f.element_name%type

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

Line 572: from pay_element_types_f elt,

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

Line 701: ,p_element_name in pay_element_types_f.element_name%type

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

Line 768: l_element_type_id pay_element_types_f.element_type_id%type;

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

Line 803: l_processing_type pay_element_types_f.processing_type%type;

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

Line 837: from pay_element_types_f elt

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

Line 862: FROM pay_element_entries_f ee, pay_element_types_f et

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