APPS.HR_GBBAL dependencies on DUAL

Line 3251: FROM DUAL;

3247: SELECT
3248: pay_balance_dimensions_s.NEXTVAL
3249: INTO
3250: l_bal_next
3251: FROM DUAL;
3252:
3253: l_route_text :=
3254: 'pay_gb_balances_v TARGET,
3255: pay_dummy_feeds_v FEED

Line 3851: -- individual balances.

3847: end if;
3848: --
3849: -- first time through check whether any balance initializations have happened
3850: -- in the tax year - if not we don't need to check the initialization on
3851: -- individual balances.
3852:
3853:
3854:
3855: begin

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

4021: -- first check for the normal run indirects in the year
4022: -- The normal way for NI Balances is fed is from indirects
4023: -- returned by the NI Formula.
4024: -- exceptionally users adjust NI balances in a run or adjustment
4025: -- by giving an individual NI Category Element to an assignment
4026: -- the ni_run_result cursor caters for these two types of
4027: -- results using the optimal N51 index to retreive results.
4028: -- To achieve this it joins first to the element entries
4029: -- Table for a list of NI elements defined in a user table.

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

4149: --
4150: ELSE
4151: --
4152: -- The latest balances are not null or 0, so there must be a
4153: -- balance value for this category, set the individual existance
4154: -- variables due to reset of master return variable below.
4155: --
4156: if P_category = 'A' then g_ni_a_exists := 1; end if;
4157: if P_category = 'B' then g_ni_b_exists := 1; end if;