APPS.HRASSACT dependencies on PAY_BALANCE_DIMENSIONS

Line 2442: pay_balance_dimensions pbd

2438: cursor pl_feed_chk_a is
2439: select alb.latest_balance_id
2440: from pay_assignment_latest_balances alb,
2441: pay_defined_balances pdb,
2442: pay_balance_dimensions pbd
2443: where pdb.balance_type_id = l_balance_type_id
2444: and pdb.defined_balance_id = alb.defined_balance_id
2445: and pdb.balance_dimension_id = pbd.balance_dimension_id
2446: and pbd.feed_checking_type = 'F';

Line 2453: pay_balance_dimensions pbd

2449: select plb.latest_balance_id,
2450: 'P' balance_type
2451: from pay_person_latest_balances plb,
2452: pay_defined_balances pdb,
2453: pay_balance_dimensions pbd
2454: where pdb.balance_type_id = l_balance_type_id
2455: and pdb.defined_balance_id = plb.defined_balance_id
2456: and pdb.balance_dimension_id = pbd.balance_dimension_id
2457: and pbd.feed_checking_type = 'F'

Line 2463: pay_balance_dimensions pbd

2459: select plb.latest_balance_id,
2460: 'B' balance_type
2461: from pay_latest_balances plb,
2462: pay_defined_balances pdb,
2463: pay_balance_dimensions pbd
2464: where pdb.balance_type_id = l_balance_type_id
2465: and pdb.defined_balance_id = plb.defined_balance_id
2466: and pdb.balance_dimension_id = pbd.balance_dimension_id
2467: and pbd.feed_checking_type = 'F';

Line 6872: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;

6868: bus_grp_id per_all_assignments_f.business_group_id%TYPE;
6869: l_person_id per_all_assignments_f.person_id%TYPE;
6870: cxt_id number;
6871: tax_unit_id number;
6872: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;
6873: balance_expiry_code pay_balance_dimensions.expiry_checking_code%TYPE;
6874: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;
6875: bal_context_string varchar2(2000);
6876: bal_fed boolean;

Line 6873: balance_expiry_code pay_balance_dimensions.expiry_checking_code%TYPE;

6869: l_person_id per_all_assignments_f.person_id%TYPE;
6870: cxt_id number;
6871: tax_unit_id number;
6872: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;
6873: balance_expiry_code pay_balance_dimensions.expiry_checking_code%TYPE;
6874: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;
6875: bal_context_string varchar2(2000);
6876: bal_fed boolean;
6877: l_change_flag boolean;

Line 6874: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;

6870: cxt_id number;
6871: tax_unit_id number;
6872: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;
6873: balance_expiry_code pay_balance_dimensions.expiry_checking_code%TYPE;
6874: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;
6875: bal_context_string varchar2(2000);
6876: bal_fed boolean;
6877: l_change_flag boolean;
6878: l_rule_mode pay_legislation_rules.rule_mode%TYPE;

Line 7451: feed_checking_type pay_balance_dimensions.feed_checking_type%TYPE;

7447: ) return boolean is
7448: feed_balance boolean;
7449: --
7450: c_indent constant varchar2(30) := 'hrassact.feed_check';
7451: feed_checking_type pay_balance_dimensions.feed_checking_type%TYPE;
7452: feed_checking_code pay_balance_dimensions.feed_checking_code%TYPE;
7453: dim_num number;
7454: found boolean := FALSE;
7455: --

Line 7452: feed_checking_code pay_balance_dimensions.feed_checking_code%TYPE;

7448: feed_balance boolean;
7449: --
7450: c_indent constant varchar2(30) := 'hrassact.feed_check';
7451: feed_checking_type pay_balance_dimensions.feed_checking_type%TYPE;
7452: feed_checking_code pay_balance_dimensions.feed_checking_code%TYPE;
7453: dim_num number;
7454: found boolean := FALSE;
7455: --
7456: begin

Line 7489: from pay_balance_dimensions pbd

7485: feed_checking_type,
7486: feed_checking_code,
7487: bal_exp_code,
7488: bal_exp_level
7489: from pay_balance_dimensions pbd
7490: where pbd.balance_dimension_id = bal_dim_id;
7491:
7492: -- put into cache
7493: bal_dims.sz := bal_dims.sz + 1;