APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 318: l_source pay_run_result_values.result_value%type;

314: l_action_info_id NUMBER;
315: l_balance_value NUMBER;
316: l_ovn NUMBER;
317: l_tax_unit_id pay_assignment_actions.tax_unit_id%type; /* Bug No : 2518997 */
318: l_source pay_run_result_values.result_value%type;
319:
320: /* Start of Bug No : 2518997 */
321:
322: CURSOR csr_tax_unit_id(p_run_assignment_action_id pay_assignment_actions.tax_unit_id%type)

Line 335: from pay_run_result_values CONTEXT

331:
332: CURSOR csr_set_source_id(p_run_assignment_action_id pay_assignment_actions.tax_unit_id%type)
333: IS
334: select distinct CONTEXT.result_value
335: from pay_run_result_values CONTEXT
336: ,pay_input_values_f PIVF
337: ,pay_run_results RR
338: ,pay_payroll_actions PACT,
339: pay_assignment_actions paa

Line 496: FROM pay_run_result_values prv,

492: p_element_type_id NUMBER,
493: p_input_value_id NUMBER)
494: IS
495: SELECT prv.result_value value
496: FROM pay_run_result_values prv,
497: pay_run_results prr
498: WHERE prr.status IN ('P','PA')
499: AND prv.run_result_id = prr.run_result_id
500: AND prr.assignment_action_id = p_assignment_action_id

Line 512: FROM pay_run_result_values prv,

508: p_element_type_id NUMBER,
509: p_input_value_id NUMBER)
510: IS
511: SELECT sum(fnd_number.canonical_to_number(prv.result_value)) value/*Bug 3228928*/
512: FROM pay_run_result_values prv,
513: pay_run_results prr
514: WHERE prr.status IN ('P','PA')
515: AND prv.run_result_id = prr.run_result_id
516: AND prr.assignment_action_id = p_assignment_action_id