[Home] [Help]
484: l_balance_type_id number;
485: --
486: cursor get_balance_type_id (c_balance_name in varchar2) is
487: select balance_type_id
488: from pay_balance_types
489: where balance_name = c_balance_name
490: and legislation_code = 'US';
491: --
492: BEGIN
678: c_date_earned in date,
679: c_date2_earned in date )
680: is
681: select distinct PAR.assignment_id
682: from pay_balance_types PBT,
683: pay_us_asg_reporting PAR
684: where PAR.tax_unit_id = c_tax_unit_id
685: and PBT.balance_type_id = c_balance_type_id
686: and PBT.jurisdiction_level <> 0
1009: CURSOR csr_get_def_balance(p_balance_name varchar2
1010: ,p_dimension_suffix varchar2
1011: ,p_business_group_id number) IS
1012: SELECT pdb.defined_balance_id
1013: FROM pay_balance_types pbt
1014: ,pay_balance_dimensions pbd
1015: ,pay_defined_balances pdb
1016: WHERE upper(pbt.balance_name) = p_balance_name
1017: AND ((pbt.business_group_id = p_business_group_id)
3257: -- Description: This procedure is passed up to ten balances (using balance name).
3258: -- It calculates the GRE_YTD dimension figure of the balance(s) at
3259: -- GROUP LEVEL only, as at the effective date (also passed in).
3260: -- The route code for GRE_YTD is copied from the correspoding
3261: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added
3262: -- so that balance names can be used to match on balance feeds
3263: -- for this balance. This method of multiple-decode select means
3264: -- that selecting 10 balances takes the same amount of time as selecting
3265: -- a single balance in the previous implementation.
3402: -- Description: This procedure is passed up to ten balances (using balance name).
3403: -- It calculates the GRE_QTD dimension figure of the balance(s) at
3404: -- GROUP LEVEL only, as at the effective date (also passed in).
3405: -- The route code for GRE_QTD is copied from the correspoding
3406: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added
3407: -- so that balance names can be used to match on balance feeds
3408: -- for this balance. This method of multiple-decode select means
3409: -- that selecting 10 balances takes the same amount of time as selecting
3410: -- a single balance in the previous implementation.
3751: and PACT.date_earned between ET.effective_start_date
3752: and ET.effective_end_date
3753: and TR.classification_id = ET.classification_id + 0
3754: and TR.tax_category = ET.element_information1
3755: and TR.tax_type = (select bt.tax_type from pay_balance_types bt
3756: where bt.balance_type_id = FEED.balance_type_id)
3757: and TR.jurisdiction_code = '00-000-0000'||decode(RR.run_result_id,null,', ')
3758: and nvl(TR.status,'X') <>'D'); -- Bug 3251672
3759:
3858: and PACT.date_earned between ET.effective_start_date
3859: and ET.effective_end_date
3860: and TR.classification_id = ET.classification_id + 0
3861: and TR.tax_category = ET.element_information1
3862: and TR.tax_type = (select bt.tax_type from pay_balance_types bt
3863: where bt.balance_type_id = FEED.balance_type_id)
3864: and TR.jurisdiction_code = '00-000-0000'||decode(RR.run_result_id,null,', ')
3865: and nvl(TR.status,'X') <>'D'); -- Bug 3251672
3866:
4117: -- Description: This procedure is passed up to ten balances (using balance name).
4118: -- It calculates the GRE_MTD dimension figure of the balance(s) at
4119: -- GROUP LEVEL only, as at the effective date (also passed in).
4120: -- The route code for GRE_MTD is copied from the correspoding
4121: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added
4122: -- so that balance names can be used to match on balance feeds
4123: -- for this balance. This method of multiple-decode select means
4124: -- that selecting 10 balances takes the same amount of time as selecting
4125: -- a single balance in the previous implementation.
4262: -- Description: This procedure is passed up to ten balances (using balance name).
4263: -- It calculates the GRE_CTD dimension figure of the balance(s) at
4264: -- GROUP LEVEL only, as at the effective date (also passed in).
4265: -- The route code for GRE_CTD is copied from the correspoding
4266: -- row in FF_ROUTES, plus the PAY_BALANCE_TYPES table is added
4267: -- so that balance names can be used to match on balance feeds
4268: -- for this balance. This method of multiple-decode select means
4269: -- that selecting 10 balances takes the same amount of time as selecting
4270: -- a single balance in the previous implementation.
4483: and PACT.date_earned between ET.effective_start_date
4484: and ET.effective_end_date
4485: and TR.classification_id = ET.classification_id + 0
4486: and TR.tax_category = ET.element_information1
4487: and TR.tax_type = (select bt.tax_type from pay_balance_types bt
4488: where bt.balance_type_id = FEED.balance_type_id)
4489: and TR.jurisdiction_code = '00-000-0000'||decode(RR.run_result_id,null,', ')
4490: and nvl(TR.status,'X') <>'D') ; -- Bug 3251672
4491:
4591: and PACT.date_earned between ET.effective_start_date
4592: and ET.effective_end_date
4593: and TR.classification_id = ET.classification_id + 0
4594: and TR.tax_category = ET.element_information1
4595: and TR.tax_type = (select bt.tax_type from pay_balance_types bt
4596: where bt.balance_type_id = FEED.balance_type_id)
4597: and TR.jurisdiction_code = '00-000-0000'||decode(RR.run_result_id,null,', ')
4598: and nvl(TR.status,'X') <>'D') ; -- Bug 3251672
4599: