APPS.HR_RUNGEN dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 65: pay_element_entry_values_f EEV,

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)
69: BETWEEN ELE.effective_start_date

Line 80: pay_element_entry_values_f EEV2,

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
84: AND ELE2.element_entry_id

Line 107: pay_element_entry_values_f EEV,

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)
111: BETWEEN ELE.effective_start_date

Line 122: pay_element_entry_values_f EEV2,

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
126: = ELE.element_entry_id

Line 141: pay_element_entry_values_f EEV3,

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
145: = ELE.element_entry_id

Line 167: pay_element_entry_values_f EEV,

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)
171: BETWEEN ELE.effective_start_date

Line 182: pay_element_entry_values_f EEV2,

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
186: = ELE.element_entry_id

Line 306: pay_element_entry_values_f EEV,

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)
310: BETWEEN ELE.effective_start_date