APPS.HR_RUNGEN dependencies on PAY_INPUT_VALUES_F

Line 66: pay_input_values_f IPV

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
70: AND ELE.effective_end_date

Line 81: pay_input_values_f IPV2

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

Line 108: pay_input_values_f IPV

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
112: AND ELE.effective_end_date

Line 123: pay_input_values_f IPV2

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
127: AND fnd_date.canonical_to_date(p_payact_earned_date)

Line 142: pay_input_values_f IPV3

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
146: AND fnd_date.canonical_to_date(p_payact_earned_date)

Line 168: pay_input_values_f IPV

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
172: AND ELE.effective_end_date

Line 183: pay_input_values_f IPV2

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
187: AND fnd_date.canonical_to_date(p_payact_earned_date)

Line 202: pay_input_values_f IPV3

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
205: = ELE.element_entry_id
206: AND fnd_date.canonical_to_date(p_payact_earned_date)

Line 307: pay_input_values_f IPV

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
311: AND ELE.effective_end_date