APPS.HRASSACT dependencies on PAY_BALANCE_TYPES

Line 7048: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;

7044: l_feed_flag boolean;
7045: l_match boolean;
7046:
7047: c_indent constant varchar2(35) := 'hrassact.lb_context_match_check';
7048: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;
7049: cnt number;
7050: l_tax_unit_id number;
7051: l_jurisdiction_code pay_run_result_values.result_value%type;
7052: l_original_entry_id number;

Line 7108: from pay_balance_types

7104: if (udca.cxt_name(cnt) = 'JURISDICTION_CODE') then
7105: l_match := TRUE;
7106: select nvl(jurisdiction_level, 0)
7107: into l_jurisdiction_level
7108: from pay_balance_types
7109: where balance_type_id = p_bal_type_id;
7110: if substr(udca.cxt_value(cnt), 1, l_jurisdiction_level) <>
7111: l_jurisdiction_code then
7112: -- jurisdiction_code to required level does not match

Line 7355: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;

7351: from pay_balance_context_values
7352: where latest_balance_id = p_lat_bal_id;
7353:
7354: c_indent constant varchar2(35) := 'hrassact.context_match_check';
7355: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;
7356: cnt number;
7357: --
7358: begin
7359: --

Line 7381: from pay_balance_types

7377: if udca.cxt_name(cnt) = 'JURISDICTION_CODE' then
7378:
7379: select nvl(jurisdiction_level, 0)
7380: into l_jurisdiction_level
7381: from pay_balance_types
7382: where balance_type_id = p_bal_type_id;
7383:
7384: if substr(udca.cxt_value(cnt), 1, l_jurisdiction_level) <>
7385: bcv.value then