DBA Data[Home] [Help]

APPS.PAY_NO_HIGH_RATE_TAX dependencies on PAY_RANGES_F

Line 550: from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF

546:
547: /*
548: cursor csr_get_normal_tax (l_table_number varchar2 , l_freq varchar2 , l_type varchar2 , l_bg_id number ,l_date date,l_amount varchar2) is
549: Select Amount1
550: from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF
551: where PRTF.range_table_id = PRF.range_table_id
552: and PRTF.range_table_number = TO_NUMBER(l_table_number)
553: and PRTF.period_frequency = l_freq
554: and PRTF.earnings_type = l_type

Line 567: from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF

563: -- Modifying cursor to check for business_gorup_id IS NULL
564:
565: cursor csr_get_normal_tax (l_table_number varchar2 , l_freq varchar2 , l_type varchar2 ,l_date date,l_amount varchar2) is
566: Select Amount1
567: from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF
568: where PRTF.range_table_id = PRF.range_table_id
569: and PRTF.range_table_number = TO_NUMBER(l_table_number)
570: and PRTF.period_frequency = l_freq
571: and PRTF.earnings_type = l_type