DBA Data[Home] [Help]

APPS.HR_SCL_FLEX dependencies on PAY_WC_RATES

Line 556: From PAY_WC_RATES wcr,

552: l_location_id number;
553: --
554: cursor csr_chk_wc_override is
555: Select null
556: From PAY_WC_RATES wcr,
557: PAY_WC_FUNDS wcf,
558: HR_ORGANIZATION_INFORMATION org,
559: PAY_EMP_FED_TAX_V1 ftr
560: where wcr.fund_id = wcf.fund_id

Line 567: from pay_wc_rates wcr1,

563: ( wcf.location_id is null
564: and not exists
565: (
566: select 1
567: from pay_wc_rates wcr1,
568: pay_wc_funds wcf1
569: where wcr1.wc_code = wcr.wc_code
570: and wcr1.fund_id = wcf1.fund_id
571: and wcf1.location_id = p_location_id