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_BALANCE_TYPES

Line 457: from pay_balance_types

453: l_balance_type_id number;
454: --
455: cursor get_balance_type_id (c_balance_name in varchar2) is
456: select balance_type_id
457: from pay_balance_types
458: where balance_name = c_balance_name
459: and legislation_code = 'US';
460: --
461: BEGIN

Line 651: from pay_balance_types PBT,

647: c_date_earned in date,
648: c_date2_earned in date )
649: is
650: select distinct PAR.assignment_id
651: from pay_balance_types PBT,
652: pay_us_asg_reporting PAR
653: where PAR.tax_unit_id = c_tax_unit_id
654: and PBT.balance_type_id = c_balance_type_id
655: and PBT.jurisdiction_level <> 0

Line 2850: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added

2846: -- Description: This procedure is passed up to ten balances (using balance name).
2847: -- It calculates the GRE_YTD dimension figure of the balance(s) at
2848: -- GROUP LEVEL only, as at the effective date (also passed in).
2849: -- The route code for GRE_YTD is copied from the correspoding
2850: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added
2851: -- so that balance names can be used to match on balance feeds
2852: -- for this balance. This method of multiple-decode select means
2853: -- that selecting 10 balances takes the same amount of time as selecting
2854: -- a single balance in the previous implementation.

Line 2995: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added

2991: -- Description: This procedure is passed up to ten balances (using balance name).
2992: -- It calculates the GRE_QTD dimension figure of the balance(s) at
2993: -- GROUP LEVEL only, as at the effective date (also passed in).
2994: -- The route code for GRE_QTD is copied from the correspoding
2995: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added
2996: -- so that balance names can be used to match on balance feeds
2997: -- for this balance. This method of multiple-decode select means
2998: -- that selecting 10 balances takes the same amount of time as selecting
2999: -- a single balance in the previous implementation.

Line 3285: and TR.tax_type = (select bt.tax_type from pay_balance_types bt

3281: and PACT.date_earned between ET.effective_start_date
3282: and ET.effective_end_date
3283: and TR.classification_id = ET.classification_id + 0
3284: and TR.tax_category = ET.element_information1
3285: and TR.tax_type = (select bt.tax_type from pay_balance_types bt
3286: where bt.balance_type_id = FEED.balance_type_id)
3287: and TR.jurisdiction_code = '00-000-0000'||decode(RR.run_result_id,null,', ')
3288: and nvl(TR.status,'X') <>'D'); -- Bug 3251672
3289:

Line 3392: and TR.tax_type = (select bt.tax_type from pay_balance_types bt

3388: and PACT.date_earned between ET.effective_start_date
3389: and ET.effective_end_date
3390: and TR.classification_id = ET.classification_id + 0
3391: and TR.tax_category = ET.element_information1
3392: and TR.tax_type = (select bt.tax_type from pay_balance_types bt
3393: where bt.balance_type_id = FEED.balance_type_id)
3394: and TR.jurisdiction_code = '00-000-0000'||decode(RR.run_result_id,null,', ')
3395: and nvl(TR.status,'X') <>'D'); -- Bug 3251672
3396:

Line 3651: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added

3647: -- Description: This procedure is passed up to ten balances (using balance name).
3648: -- It calculates the GRE_MTD dimension figure of the balance(s) at
3649: -- GROUP LEVEL only, as at the effective date (also passed in).
3650: -- The route code for GRE_MTD is copied from the correspoding
3651: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added
3652: -- so that balance names can be used to match on balance feeds
3653: -- for this balance. This method of multiple-decode select means
3654: -- that selecting 10 balances takes the same amount of time as selecting
3655: -- a single balance in the previous implementation.

Line 3796: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added

3792: -- Description: This procedure is passed up to ten balances (using balance name).
3793: -- It calculates the GRE_CTD dimension figure of the balance(s) at
3794: -- GROUP LEVEL only, as at the effective date (also passed in).
3795: -- The route code for GRE_CTD is copied from the correspoding
3796: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added
3797: -- so that balance names can be used to match on balance feeds
3798: -- for this balance. This method of multiple-decode select means
3799: -- that selecting 10 balances takes the same amount of time as selecting
3800: -- a single balance in the previous implementation.

Line 4017: and TR.tax_type = (select bt.tax_type from pay_balance_types bt

4013: and PACT.date_earned between ET.effective_start_date
4014: and ET.effective_end_date
4015: and TR.classification_id = ET.classification_id + 0
4016: and TR.tax_category = ET.element_information1
4017: and TR.tax_type = (select bt.tax_type from pay_balance_types bt
4018: where bt.balance_type_id = FEED.balance_type_id)
4019: and TR.jurisdiction_code = '00-000-0000'||decode(RR.run_result_id,null,', ')
4020: and nvl(TR.status,'X') <>'D') ; -- Bug 3251672
4021:

Line 4125: and TR.tax_type = (select bt.tax_type from pay_balance_types bt

4121: and PACT.date_earned between ET.effective_start_date
4122: and ET.effective_end_date
4123: and TR.classification_id = ET.classification_id + 0
4124: and TR.tax_category = ET.element_information1
4125: and TR.tax_type = (select bt.tax_type from pay_balance_types bt
4126: where bt.balance_type_id = FEED.balance_type_id)
4127: and TR.jurisdiction_code = '00-000-0000'||decode(RR.run_result_id,null,', ')
4128: and nvl(TR.status,'X') <>'D') ; -- Bug 3251672
4129: