eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_TAXABILITY_RULES

Line 130: kaverma 19-NOV-2003 115.43 Added status <> 'D' for pay_taxability_rules

126: with respect to the CURRENT Dimension, removed the
127: REV_CHK work around and implemented the ASG_PAYMENTS
128: balance dimension. I also modified US_TAX_BALANCE
129: to accept ASG_PAYMENTS as a vaild time_type.
130: kaverma 19-NOV-2003 115.43 Added status <> 'D' for pay_taxability_rules
131: kaverma 21-NOV-2003 115.44 Corrected join for pay_taxability_rules as
132: nvl(status,'X') <> 'D'
133: sdahiya 12-JAN-2004 115.45 Modified query for performance (Bug 3343982).
134: tclewis 14-JAN-2004 115.46 Added STEIC to check of Taxable and excess bal.

Line 131: kaverma 21-NOV-2003 115.44 Corrected join for pay_taxability_rules as

127: REV_CHK work around and implemented the ASG_PAYMENTS
128: balance dimension. I also modified US_TAX_BALANCE
129: to accept ASG_PAYMENTS as a vaild time_type.
130: kaverma 19-NOV-2003 115.43 Added status <> 'D' for pay_taxability_rules
131: kaverma 21-NOV-2003 115.44 Corrected join for pay_taxability_rules as
132: nvl(status,'X') <> 'D'
133: sdahiya 12-JAN-2004 115.45 Modified query for performance (Bug 3343982).
134: tclewis 14-JAN-2004 115.46 Added STEIC to check of Taxable and excess bal.
135: djoshi 29-JAN-2004 115.47 Changed the function payments_balance_required

Line 3748: from pay_taxability_rules TR,

3744: c_balance_type_id5)
3745: and PACT.effective_date between FEED.effective_start_date
3746: and FEED.effective_end_date
3747: and EXISTS ( select 'x'
3748: from pay_taxability_rules TR,
3749: pay_element_types_f ET
3750: where ET.element_type_id = RR.element_type_id
3751: and PACT.date_earned between ET.effective_start_date
3752: and ET.effective_end_date

Line 3855: from pay_taxability_rules TR,

3851: c_balance_type_id5)
3852: and PACT.effective_date between FEED.effective_start_date
3853: and FEED.effective_end_date
3854: and EXISTS ( select 'x'
3855: from pay_taxability_rules TR,
3856: pay_element_types_f ET
3857: where ET.element_type_id = RR.element_type_id
3858: and PACT.date_earned between ET.effective_start_date
3859: and ET.effective_end_date

Line 4480: from pay_taxability_rules TR,

4476: c_balance_type_id5)
4477: and PACT.effective_date between FEED.effective_start_date
4478: and FEED.effective_end_date
4479: and EXISTS ( select 'x'
4480: from pay_taxability_rules TR,
4481: pay_element_types_f ET
4482: where ET.element_type_id = RR.element_type_id
4483: and PACT.date_earned between ET.effective_start_date
4484: and ET.effective_end_date

Line 4588: from pay_taxability_rules TR,

4584: c_balance_type_id5)
4585: and PACT.effective_date between FEED.effective_start_date
4586: and FEED.effective_end_date
4587: and EXISTS ( select 'x'
4588: from pay_taxability_rules TR,
4589: pay_element_types_f ET
4590: where ET.element_type_id = RR.element_type_id
4591: and PACT.date_earned between ET.effective_start_date
4592: and ET.effective_end_date