APPS.HR_GBBAL dependencies on DUAL

Line 3267: FROM DUAL;

3263: SELECT
3264: pay_balance_dimensions_s.NEXTVAL
3265: INTO
3266: l_bal_next
3267: FROM DUAL;
3268:
3269: l_route_text :=
3270: 'pay_gb_balances_v TARGET,
3271: pay_dummy_feeds_v FEED

Line 3934: -- individual balances.

3930: end if;
3931: --
3932: -- first time through check whether any balance initializations have happened
3933: -- in the tax year - if not we don't need to check the initialization on
3934: -- individual balances.
3935:
3936:
3937:
3938: begin

Line 4108: -- by giving an individual NI Category Element to an assignment

4104: -- first check for the normal run indirects in the year
4105: -- The normal way for NI Balances is fed is from indirects
4106: -- returned by the NI Formula.
4107: -- exceptionally users adjust NI balances in a run or adjustment
4108: -- by giving an individual NI Category Element to an assignment
4109: -- the ni_run_result cursor caters for these two types of
4110: -- results using the optimal N51 index to retreive results.
4111: -- To achieve this it joins first to the element entries
4112: -- Table for a list of NI elements defined in a user table.

Line 4236: -- balance value for this category, set the individual existance

4232: --
4233: ELSE
4234: --
4235: -- The latest balances are not null or 0, so there must be a
4236: -- balance value for this category, set the individual existance
4237: -- variables due to reset of master return variable below.
4238: --
4239: if P_category = 'A' then g_ni_a_exists := 1; end if;
4240: if P_category = 'B' then g_ni_b_exists := 1; end if;