APPS.PAY_PAYGTN_PKG dependencies on PAY_RUN_RESULTS

Line 354: pay_run_results rr

350: where exists (
351: select 'Y'
352: from pay_run_result_values rrv,
353: pay_input_values_F iv,
354: pay_run_results rr
355: where nvl(rrv.result_value,0) <> to_char(0)
356: and iv.input_value_id = rrv.input_value_id
357: and iv.element_type_id = rr.element_type_id
358: and iv.name = 'Pay Value'

Line 560: pay_run_results rr

556: where exists (
557: select 'Y'
558: from pay_run_result_values rrv,
559: pay_input_values_F iv,
560: pay_run_results rr
561: where nvl(rrv.result_value,0) <> to_char(0)
562: and iv.input_value_id = rrv.input_value_id
563: and iv.name = 'Pay Value'
564: and iv.element_type_id = rr.element_type_id

Line 851: p_futa_from := ' pay_run_results prr ';

847: else
848: p_futa_where := ' prr.status in ('||'''P'''||','||'''PA'''||')
849: and pet.element_type_id = prr.element_type_id
850: and prr.assignment_action_id = ';
851: p_futa_from := ' pay_run_results prr ';
852: end if; */
853: /* -- Bug#4942114 ends --*/
854: p_er_liab_status := pay_us_payroll_utils.check_balance_status(p_start_date
855: ,p_business_group_id

Line 878: p_er_liab_from := ' pay_run_results prr ';

874: else
875: p_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
876: and prr.status in (' || '''P''' || ', ' || '''PA''' || ')
877: and prr.assignment_action_id = ';
878: p_er_liab_from := ' pay_run_results prr ';
879: end if; */
880: /*-- Bug#4942114 ends --*/
881:
882: open c_wc_er_liab_valid_count(p_business_group_id,l_trunc_date);

Line 907: p_wc_er_liab_from := ' pay_run_results prr ';

903:
904: else
905: p_wc_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
906: and prr.assignment_action_id = paa.assignment_action_id';
907: p_wc_er_liab_from := ' pay_run_results prr ';
908: end if; */
909: /*-- Bug#4942114 ends --*/
910:
911: exception