APPS.PAY_BALANCE_FEED_DEL_PKG dependencies on PAY_RUN_RESULTS

Line 181: from pay_run_results prr,

177: where pdb.balance_type_id = l_balance_type_id
178: and plb.defined_balance_id = pdb.defined_balance_id
179: and exists (
180: select null
181: from pay_run_results prr,
182: pay_run_result_values rrv
183: where rrv.input_value_id = l_input_value_id
184: and prr.run_result_id = rrv.run_result_id
185: and prr.status in ('P', 'PA')

Line 197: from pay_run_results prr,

193: where pdb.balance_type_id = l_balance_type_id
194: and lb.defined_balance_id = pdb.defined_balance_id
195: and exists (
196: select null
197: from pay_run_results prr,
198: pay_run_result_values rrv
199: where rrv.input_value_id = l_input_value_id
200: and prr.run_result_id = rrv.run_result_id
201: and prr.status in ('P', 'PA')

Line 231: from pay_run_results prr,

227: -- Select if run result value exists for input value
228: cursor ivchk is
229: select '1' from dual
230: where exists (select 1
231: from pay_run_results prr,
232: pay_run_result_values rrv
233: where rrv.input_value_id = l_input_value_id
234: and prr.run_result_id = rrv.run_result_id
235: and prr.status in ('P', 'PA')

Line 944: from pay_run_results prr,

940: and plb.defined_balance_id = pdb.defined_balance_id
941: and plb.assignment_id between p_assnmnt_start_id and p_assnmnt_end_id
942: and exists (
943: select null
944: from pay_run_results prr,
945: pay_run_result_values rrv
946: where rrv.input_value_id = p_input_value_id
947: and prr.run_result_id = rrv.run_result_id
948: and prr.status in ('P', 'PA')