APPS.PAY_PAYGTN_PKG dependencies on PAY_RUN_RESULTS

Line 363: pay_run_results rr

359: where exists (
360: select 'Y'
361: from pay_run_result_values rrv,
362: pay_input_values_F iv,
363: pay_run_results rr
364: where nvl(rrv.result_value,0) <> to_char(0)
365: and iv.input_value_id = rrv.input_value_id
366: and iv.element_type_id = rr.element_type_id
367: and iv.name = 'Pay Value'

Line 569: pay_run_results rr

565: where exists (
566: select 'Y'
567: from pay_run_result_values rrv,
568: pay_input_values_F iv,
569: pay_run_results rr
570: where nvl(rrv.result_value,0) <> to_char(0)
571: and iv.input_value_id = rrv.input_value_id
572: and iv.name = 'Pay Value'
573: and iv.element_type_id = rr.element_type_id

Line 860: p_futa_from := ' pay_run_results prr ';

856: else
857: p_futa_where := ' prr.status in ('||'''P'''||','||'''PA'''||')
858: and pet.element_type_id = prr.element_type_id
859: and prr.assignment_action_id = ';
860: p_futa_from := ' pay_run_results prr ';
861: end if; */
862: /* -- Bug#4942114 ends --*/
863: p_er_liab_status := pay_us_payroll_utils.check_balance_status(p_start_date
864: ,p_business_group_id

Line 887: p_er_liab_from := ' pay_run_results prr ';

883: else
884: p_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
885: and prr.status in (' || '''P''' || ', ' || '''PA''' || ')
886: and prr.assignment_action_id = ';
887: p_er_liab_from := ' pay_run_results prr ';
888: end if; */
889: /*-- Bug#4942114 ends --*/
890:
891: open c_wc_er_liab_valid_count(p_business_group_id,l_trunc_date);

Line 916: p_wc_er_liab_from := ' pay_run_results prr ';

912:
913: else
914: p_wc_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
915: and prr.assignment_action_id = paa.assignment_action_id';
916: p_wc_er_liab_from := ' pay_run_results prr ';
917: end if; */
918: /*-- Bug#4942114 ends --*/
919:
920: exception