APPS.HRASSACT dependencies on PAY_BALANCE_DIMENSIONS

Line 2474: pay_balance_dimensions pbd

2470: cursor pl_feed_chk_a is
2471: select alb.latest_balance_id
2472: from pay_assignment_latest_balances alb,
2473: pay_defined_balances pdb,
2474: pay_balance_dimensions pbd
2475: where pdb.balance_type_id = l_balance_type_id
2476: and pdb.defined_balance_id = alb.defined_balance_id
2477: and pdb.balance_dimension_id = pbd.balance_dimension_id
2478: and pbd.feed_checking_type = 'F';

Line 2485: pay_balance_dimensions pbd

2481: select plb.latest_balance_id,
2482: 'P' balance_type
2483: from pay_person_latest_balances plb,
2484: pay_defined_balances pdb,
2485: pay_balance_dimensions pbd
2486: where pdb.balance_type_id = l_balance_type_id
2487: and pdb.defined_balance_id = plb.defined_balance_id
2488: and pdb.balance_dimension_id = pbd.balance_dimension_id
2489: and pbd.feed_checking_type = 'F'

Line 2495: pay_balance_dimensions pbd

2491: select plb.latest_balance_id,
2492: 'B' balance_type
2493: from pay_latest_balances plb,
2494: pay_defined_balances pdb,
2495: pay_balance_dimensions pbd
2496: where pdb.balance_type_id = l_balance_type_id
2497: and pdb.defined_balance_id = plb.defined_balance_id
2498: and pdb.balance_dimension_id = pbd.balance_dimension_id
2499: and pbd.feed_checking_type = 'F';

Line 7136: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;

7132: bus_grp_id per_all_assignments_f.business_group_id%TYPE;
7133: l_person_id per_all_assignments_f.person_id%TYPE;
7134: cxt_id number;
7135: tax_unit_id number;
7136: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;
7137: balance_expiry_code pay_balance_dimensions.expiry_checking_code%TYPE;
7138: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;
7139: bal_context_string varchar2(2000);
7140: bal_fed boolean;

Line 7137: balance_expiry_code pay_balance_dimensions.expiry_checking_code%TYPE;

7133: l_person_id per_all_assignments_f.person_id%TYPE;
7134: cxt_id number;
7135: tax_unit_id number;
7136: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;
7137: balance_expiry_code pay_balance_dimensions.expiry_checking_code%TYPE;
7138: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;
7139: bal_context_string varchar2(2000);
7140: bal_fed boolean;
7141: l_change_flag boolean;

Line 7138: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;

7134: cxt_id number;
7135: tax_unit_id number;
7136: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;
7137: balance_expiry_code pay_balance_dimensions.expiry_checking_code%TYPE;
7138: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;
7139: bal_context_string varchar2(2000);
7140: bal_fed boolean;
7141: l_change_flag boolean;
7142: l_rule_mode pay_legislation_rules.rule_mode%TYPE;

Line 7716: feed_checking_type pay_balance_dimensions.feed_checking_type%TYPE;

7712: ) return boolean is
7713: feed_balance boolean;
7714: --
7715: c_indent constant varchar2(30) := 'hrassact.feed_check';
7716: feed_checking_type pay_balance_dimensions.feed_checking_type%TYPE;
7717: feed_checking_code pay_balance_dimensions.feed_checking_code%TYPE;
7718: dim_num number;
7719: found boolean := FALSE;
7720: --

Line 7717: feed_checking_code pay_balance_dimensions.feed_checking_code%TYPE;

7713: feed_balance boolean;
7714: --
7715: c_indent constant varchar2(30) := 'hrassact.feed_check';
7716: feed_checking_type pay_balance_dimensions.feed_checking_type%TYPE;
7717: feed_checking_code pay_balance_dimensions.feed_checking_code%TYPE;
7718: dim_num number;
7719: found boolean := FALSE;
7720: --
7721: begin

Line 7754: from pay_balance_dimensions pbd

7750: feed_checking_type,
7751: feed_checking_code,
7752: bal_exp_code,
7753: bal_exp_level
7754: from pay_balance_dimensions pbd
7755: where pbd.balance_dimension_id = bal_dim_id;
7756:
7757: -- put into cache
7758: bal_dims.sz := bal_dims.sz + 1;