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.HR_RUNGEN dependencies on PAY_ELEMENT_ENTRIES_F

Line 64: FROM pay_element_entries_f ELE,

60: -- process for SepCheck GTNs only. See below.
61: --
62: SELECT COUNT(ELE.element_entry_id)
63: INTO l_taxsep_count
64: FROM pay_element_entries_f ELE,
65: pay_element_entry_values_f EEV,
66: pay_input_values_f IPV
67: WHERE ELE.assignment_id = asgrec.assignment_id
68: AND fnd_date.canonical_to_date(p_payact_earned_date)

Line 79: FROM pay_element_entries_f ELE2,

75: AND EEV.effective_end_date
76: AND IPV.input_value_id = EEV.input_value_id
77: AND UPPER(IPV.name) = 'TAX SEPARATELY'
78: AND EXISTS (SELECT 'x'
79: FROM pay_element_entries_f ELE2,
80: pay_element_entry_values_f EEV2,
81: pay_input_values_f IPV2
82: WHERE ELE2.assignment_id
83: = asgrec.assignment_id

Line 106: FROM pay_element_entries_f ELE,

102: -- than 'A'll.
103: --
104: SELECT COUNT(ELE.element_entry_id)
105: INTO l_dednproc_count
106: FROM pay_element_entries_f ELE,
107: pay_element_entry_values_f EEV,
108: pay_input_values_f IPV
109: WHERE ELE.assignment_id = asgrec.assignment_id
110: AND fnd_date.canonical_to_date(p_payact_earned_date)

Line 121: FROM pay_element_entries_f ELE2,

117: AND EEV.effective_end_date
118: AND IPV.input_value_id = EEV.input_value_id
119: AND UPPER(IPV.name) = 'DEDUCTION PROCESSING'
120: AND EXISTS (SELECT 'x'
121: FROM pay_element_entries_f ELE2,
122: pay_element_entry_values_f EEV2,
123: pay_input_values_f IPV2
124: WHERE ELE2.assignment_id = asgrec.assignment_id
125: AND ELE2.element_entry_id

Line 140: FROM pay_element_entries_f ELE3,

136: AND IPV2.input_value_id
137: = EEV2.input_value_id
138: AND UPPER(IPV2.name) = 'SEPARATE CHECK')
139: AND EXISTS (SELECT 'x'
140: FROM pay_element_entries_f ELE3,
141: pay_element_entry_values_f EEV3,
142: pay_input_values_f IPV3
143: WHERE ELE3.assignment_id = asgrec.assignment_id
144: AND ELE3.element_entry_id

Line 166: FROM pay_element_entries_f ELE,

162: -- 'Deduction Processing' is other than 'A'll.
163: --
164: SELECT COUNT(ELE.element_entry_id)
165: INTO l_dp_nots_count
166: FROM pay_element_entries_f ELE,
167: pay_element_entry_values_f EEV,
168: pay_input_values_f IPV
169: WHERE ELE.assignment_id = asgrec.assignment_id
170: AND fnd_date.canonical_to_date(p_payact_earned_date)

Line 181: FROM pay_element_entries_f ELE2,

177: AND EEV.effective_end_date
178: AND IPV.input_value_id = EEV.input_value_id
179: AND UPPER(IPV.name) = 'DEDUCTION PROCESSING'
180: AND EXISTS (SELECT 'x'
181: FROM pay_element_entries_f ELE2,
182: pay_element_entry_values_f EEV2,
183: pay_input_values_f IPV2
184: WHERE ELE2.assignment_id = asgrec.assignment_id
185: AND ELE2.element_entry_id

Line 200: FROM pay_element_entries_f ELE3,

196: AND IPV2.input_value_id
197: = EEV2.input_value_id
198: AND UPPER(IPV2.name) = 'SEPARATE CHECK')
199: AND NOT EXISTS (SELECT 'x'
200: FROM pay_element_entries_f ELE3,
201: pay_element_links_f ELI3,
202: pay_input_values_f IPV3
203: WHERE ELE3.assignment_id = asgrec.assignment_id
204: AND ELE3.element_entry_id

Line 305: FROM pay_element_entries_f ELE,

301: --
302: --
303: SELECT COUNT(ELE.element_entry_id)
304: INTO l_sc_count
305: FROM pay_element_entries_f ELE,
306: pay_element_entry_values_f EEV,
307: pay_input_values_f IPV
308: WHERE ELE.assignment_id = asgrec.assignment_id
309: AND fnd_date.canonical_to_date(p_payact_earned_date)