APPS.HRASSACT dependencies on PAY_BALANCE_TYPES

Line 7313: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;

7309: l_feed_flag boolean;
7310: l_match boolean;
7311:
7312: c_indent constant varchar2(35) := 'hrassact.lb_context_match_check';
7313: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;
7314: cnt number;
7315: l_tax_unit_id number;
7316: l_jurisdiction_code pay_run_result_values.result_value%type;
7317: l_original_entry_id number;

Line 7373: from pay_balance_types

7369: if (udca.cxt_name(cnt) = 'JURISDICTION_CODE') then
7370: l_match := TRUE;
7371: select nvl(jurisdiction_level, 0)
7372: into l_jurisdiction_level
7373: from pay_balance_types
7374: where balance_type_id = p_bal_type_id;
7375: if substr(udca.cxt_value(cnt), 1, l_jurisdiction_level) <>
7376: l_jurisdiction_code then
7377: -- jurisdiction_code to required level does not match

Line 7620: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;

7616: from pay_balance_context_values
7617: where latest_balance_id = p_lat_bal_id;
7618:
7619: c_indent constant varchar2(35) := 'hrassact.context_match_check';
7620: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;
7621: cnt number;
7622: --
7623: begin
7624: --

Line 7646: from pay_balance_types

7642: if udca.cxt_name(cnt) = 'JURISDICTION_CODE' then
7643:
7644: select nvl(jurisdiction_level, 0)
7645: into l_jurisdiction_level
7646: from pay_balance_types
7647: where balance_type_id = p_bal_type_id;
7648:
7649: if substr(udca.cxt_value(cnt), 1, l_jurisdiction_level) <>
7650: bcv.value then