DBA Data[Home] [Help]

APPS.PAY_NO_HIGH_RATE_TAX dependencies on PAY_RANGES_F

Line 542: from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF

538:
539: /*
540: 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
541: Select Amount1
542: from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF
543: where PRTF.range_table_id = PRF.range_table_id
544: and PRTF.range_table_number = TO_NUMBER(l_table_number)
545: and PRTF.period_frequency = l_freq
546: and PRTF.earnings_type = l_type

Line 559: from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF

555: -- Modifying cursor to check for business_gorup_id IS NULL
556:
557: cursor csr_get_normal_tax (l_table_number varchar2 , l_freq varchar2 , l_type varchar2 ,l_date date,l_amount varchar2) is
558: Select Amount1
559: from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF
560: where PRTF.range_table_id = PRF.range_table_id
561: and PRTF.range_table_number = TO_NUMBER(l_table_number)
562: and PRTF.period_frequency = l_freq
563: and PRTF.earnings_type = l_type