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 3278: from pay_taxability_rules TR,

3274: c_balance_type_id5)
3275: and PACT.effective_date between FEED.effective_start_date
3276: and FEED.effective_end_date
3277: and EXISTS ( select 'x'
3278: from pay_taxability_rules TR,
3279: pay_element_types_f ET
3280: where ET.element_type_id = RR.element_type_id
3281: and PACT.date_earned between ET.effective_start_date
3282: and ET.effective_end_date

Line 3385: from pay_taxability_rules TR,

3381: c_balance_type_id5)
3382: and PACT.effective_date between FEED.effective_start_date
3383: and FEED.effective_end_date
3384: and EXISTS ( select 'x'
3385: from pay_taxability_rules TR,
3386: pay_element_types_f ET
3387: where ET.element_type_id = RR.element_type_id
3388: and PACT.date_earned between ET.effective_start_date
3389: and ET.effective_end_date

Line 4010: from pay_taxability_rules TR,

4006: c_balance_type_id5)
4007: and PACT.effective_date between FEED.effective_start_date
4008: and FEED.effective_end_date
4009: and EXISTS ( select 'x'
4010: from pay_taxability_rules TR,
4011: pay_element_types_f ET
4012: where ET.element_type_id = RR.element_type_id
4013: and PACT.date_earned between ET.effective_start_date
4014: and ET.effective_end_date

Line 4118: from pay_taxability_rules TR,

4114: c_balance_type_id5)
4115: and PACT.effective_date between FEED.effective_start_date
4116: and FEED.effective_end_date
4117: and EXISTS ( select 'x'
4118: from pay_taxability_rules TR,
4119: pay_element_types_f ET
4120: where ET.element_type_id = RR.element_type_id
4121: and PACT.date_earned between ET.effective_start_date
4122: and ET.effective_end_date