277: --
278: Cursor csr_oblig_release_processed IS
279: SELECT 'Y'
280: from pay_run_results prr
281: ,pay_run_result_values prrv
282: ,pay_input_values_f piv
283: where prr.source_id = p_element_entry_id
284: and prr.entry_type IN ('I','E')
285: and prr.status = 'P'
309:
310: CURSOR csr_prev_payout IS
311: SELECT fnd_date.canonical_to_date(prrv.result_value)
312: from pay_run_results prr
313: ,pay_run_result_values prrv
314: ,pay_element_types_f pet
315: ,pay_input_values_f piv
316: where prr.source_id = p_element_entry_id
317: and prr.entry_type IN ('I','E')
335: SELECT fnd_date.canonical_to_date(prrv.result_value)
336: from pay_payroll_actions ppa
337: ,pay_assignment_actions paa
338: ,pay_run_results prr
339: ,pay_run_result_values prrv
340: ,pay_run_result_values prrv1
341: ,pay_input_values_f piv
342: ,pay_input_values_f piv1
343: where paa.assignment_id = p_assignment_id
336: from pay_payroll_actions ppa
337: ,pay_assignment_actions paa
338: ,pay_run_results prr
339: ,pay_run_result_values prrv
340: ,pay_run_result_values prrv1
341: ,pay_input_values_f piv
342: ,pay_input_values_f piv1
343: where paa.assignment_id = p_assignment_id
344: and prr.assignment_action_id = paa.assignment_action_id