APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 320: l_source pay_run_result_values.result_value%type;

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

Line 337: from pay_run_result_values CONTEXT

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

Line 498: FROM pay_run_result_values prv,

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

Line 514: FROM pay_run_result_values prv,

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