eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BALANCE_PKG dependencies on PAY_BALANCE_VALIDATION

Line 2942: l_run_bal_status pay_balance_validation.run_balance_status%type;

2938: p_asg_action_id in number,
2939: p_status out nocopy varchar2)
2940: is
2941: --
2942: l_run_bal_status pay_balance_validation.run_balance_status%type;
2943: l_load_date pay_balance_validation.balance_load_date%type;
2944: l_retrieval_date pay_payroll_actions.effective_date%type;
2945: l_bus_grp_id pay_payroll_actions.business_group_id%type;
2946: l_payroll_id pay_payroll_actions.payroll_id%type;

Line 2943: l_load_date pay_balance_validation.balance_load_date%type;

2939: p_status out nocopy varchar2)
2940: is
2941: --
2942: l_run_bal_status pay_balance_validation.run_balance_status%type;
2943: l_load_date pay_balance_validation.balance_load_date%type;
2944: l_retrieval_date pay_payroll_actions.effective_date%type;
2945: l_bus_grp_id pay_payroll_actions.business_group_id%type;
2946: l_payroll_id pay_payroll_actions.payroll_id%type;
2947: l_period_type pay_balance_dimensions.period_type%type;

Line 2980: from pay_balance_validation pbv

2976: l_action_type := g_action_type;
2977: --
2978: select pbv.run_balance_status, pbv.balance_load_date
2979: into l_run_bal_status, l_load_date
2980: from pay_balance_validation pbv
2981: where pbv.defined_balance_id = p_run_db_id
2982: and pbv.business_group_id = l_bus_grp_id;
2983: --
2984: if (l_run_bal_status = 'V') then

Line 5938: pay_balance_validation pbv

5934: p_iv_id number)
5935: is
5936: select pdb.defined_balance_id
5937: from pay_defined_balances pdb,
5938: pay_balance_validation pbv
5939: where pdb.balance_type_id = p_bal_id
5940: and pdb.save_run_balance = 'Y'
5941: and pbv.defined_balance_id = pdb.defined_balance_id
5942: and pbv.run_balance_status in ('P', 'V');

Line 5988: update pay_balance_validation

5984: close ivchk;
5985: end if;
5986:
5987: if l_rrv_found = 1 then
5988: update pay_balance_validation
5989: set run_balance_status = 'I'
5990: where defined_balance_id = each_row.defined_balance_id;
5991: if g_debug then
5992: hr_utility.set_location('pay_balance_pkg.invalidate_run_balances', 15);

Line 6024: update pay_balance_validation

6020: hr_utility.set_location('Entering: pay_balance_pkg.invalidate_run_balances',5);
6021: end if;
6022: for each_row in get_def_bals(p_balance_type_id) loop
6023: --
6024: update pay_balance_validation
6025: set run_balance_status = 'I'
6026: where defined_balance_id = each_row.defined_balance_id;
6027: if g_debug then
6028: hr_utility.set_location('pay_balance_pkg.invalidate_run_balances', 15);

Line 8044: from pay_balance_validation pbv

8040: )
8041: and ( p_bal_list <> 'INVALID'
8042: or ( p_bal_list = 'INVALID'
8043: and exists (select ''
8044: from pay_balance_validation pbv
8045: where pbv.defined_balance_id = pdb.defined_balance_id
8046: and pbv.business_group_id = p_bus_grp_id
8047: and pbv.run_balance_status = 'P')
8048: )

Line 8159: from pay_balance_validation pbv

8155: and pba.defined_balance_id = pdb.defined_balance_id
8156: and pdb.balance_dimension_id = pbd.balance_dimension_id
8157: and pbd.dimension_level = 'GRP'
8158: and exists (select ''
8159: from pay_balance_validation pbv
8160: where pdb.defined_balance_id + decode(PDB.LEGISLATION_SUBGROUP, ' ', 0, 0) = pbv.defined_balance_id
8161: and pbv.run_balance_status = 'V'
8162: and pbv.business_group_id = p_bus_grp_id
8163: and pbv.balance_load_date is not null

Line 8837: from pay_balance_validation pbv

8833: and pdb.balance_type_id = pbt.balance_type_id
8834: and ( p_bal_list <> 'INVALID'
8835: or ( p_bal_list = 'INVALID'
8836: and exists (select ''
8837: from pay_balance_validation pbv
8838: where pbv.defined_balance_id = pdb.defined_balance_id
8839: and pbv.business_group_id = p_bus_grp_id
8840: and pbv.run_balance_status = 'P')
8841: )

Line 8949: -- from pay_balance_validation pbv

8945: -- and pba.defined_balance_id = pdb.defined_balance_id
8946: -- and pdb.balance_dimension_id = pbd.balance_dimension_id
8947: -- and pbd.dimension_level = 'ASG'
8948: -- and exists (select ''
8949: -- from pay_balance_validation pbv
8950: -- where pdb.defined_balance_id + decode(PDB.LEGISLATION_SUBGROUP, ' ', 0, 0) = pbv.defined_balance_id
8951: -- and pbv.run_balance_status = 'V'
8952: -- and pbv.business_group_id = p_bus_grp_id
8953: -- and pbv.balance_load_date is not null

Line 8994: pay_balance_validation pbv,

8990: pay_balance_feeds_f pbf,
8991: pay_defined_balances pdb,
8992: pay_balance_attributes pba,
8993: pay_balance_dimensions pbd,
8994: pay_balance_validation pbv,
8995: pay_run_result_values prrv
8996: where
8997: prr.assignment_action_id = p_asg_act_id
8998: and piv.element_type_id = prr.element_type_id

Line 9438: pay_balance_validation pbv,

9434: pdb.defined_balance_id
9435: from pay_assignment_actions paa,
9436: pay_payroll_actions ppa,
9437: per_business_groups_perf pbg,
9438: pay_balance_validation pbv,
9439: pay_defined_balances pdb,
9440: pay_balance_dimensions pbd
9441: where pbd.dimension_level = 'ASG'
9442: and pdb.save_run_balance = 'Y'

Line 9886: pay_balance_validation pbv,

9882: select /*+ ORDERED */
9883: pdb.defined_balance_id
9884: from pay_payroll_actions ppa,
9885: per_business_groups_perf pbg,
9886: pay_balance_validation pbv,
9887: pay_defined_balances pdb,
9888: pay_balance_dimensions pbd
9889: where pbd.dimension_level = 'GRP'
9890: and pdb.save_run_balance = 'Y'

Line 10017: -- pay_balance_validation. This procedure will be called from the

10013: --
10014: --------------------------------------------------------------------------
10015: -- procedure initialise_run_balance
10016: -- This procedure initialises a run balance by creating a row in
10017: -- pay_balance_validation. This procedure will be called from the
10018: -- defined_balance trigger.
10019: -- For a user defined balance, a row will be inserted for the bg of the def bal.
10020: -- For a legislative defined balance, a row will be inserted for each bg within
10021: -- the specific legislation.

Line 10090: l_bal_load_date pay_balance_validation.balance_load_date%type;

10086: --
10087: l_dim_level pay_balance_dimensions.dimension_level%type;
10088: l_leg_code per_business_groups_perf.legislation_code%type;
10089: l_bg_id per_business_groups_perf.business_group_id%type;
10090: l_bal_load_date pay_balance_validation.balance_load_date%type;
10091: l_rr_exists number;
10092: --
10093: BEGIN
10094: hr_utility.set_location('Entering: pay_balance_pkg.initialise_run_balance', 10);

Line 10151: insert into pay_balance_validation

10147: hr_utility.trace('def_bal: '||to_char(p_defbal_id));
10148: hr_utility.trace('bg: '||to_char(each_bg.business_group_id));
10149: hr_utility.trace('bal_load_date: '||to_char(l_bal_load_date,'DD-MON-YYYY'));
10150: --
10151: insert into pay_balance_validation
10152: (BALANCE_VALIDATION_ID
10153: ,DEFINED_BALANCE_ID
10154: ,BUSINESS_GROUP_ID
10155: ,RUN_BALANCE_STATUS

Line 10157: select pay_balance_validation_s.nextval

10153: ,DEFINED_BALANCE_ID
10154: ,BUSINESS_GROUP_ID
10155: ,RUN_BALANCE_STATUS
10156: ,BALANCE_LOAD_DATE)
10157: select pay_balance_validation_s.nextval
10158: ,p_defbal_id
10159: ,each_bg.business_group_id
10160: ,'V'
10161: ,l_bal_load_date

Line 10164: from pay_balance_validation

10160: ,'V'
10161: ,l_bal_load_date
10162: from dual
10163: where not exists (select 1
10164: from pay_balance_validation
10165: where defined_balance_id = p_defbal_id
10166: and business_group_id = each_bg.business_group_id);
10167: --
10168: hr_utility.set_location('pay_balance_pkg.initialise_run_balance', 90);