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_RUN_BALANCE_BUILD dependencies on PAY_BALANCE_VALIDATION

Line 33: l_bal_valid_id pay_balance_validation.balance_validation_id%type;

29: p_business_group_id in number,
30: p_status in varchar2,
31: p_from_status in varchar2)
32: is
33: l_bal_valid_id pay_balance_validation.balance_validation_id%type;
34: l_update boolean;
35: begin
36: --
37: /* Can only set a valid status if the old status was processing */

Line 52: from pay_balance_validation

48: begin
49: --
50: select balance_validation_id
51: into l_bal_valid_id
52: from pay_balance_validation
53: where defined_balance_id = p_defined_balace_id
54: and business_group_id = p_business_group_id;
55: --
56: update pay_balance_validation

Line 56: update pay_balance_validation

52: from pay_balance_validation
53: where defined_balance_id = p_defined_balace_id
54: and business_group_id = p_business_group_id;
55: --
56: update pay_balance_validation
57: set run_balance_status = p_status,
58: balance_load_date = g_start_date
59: where balance_validation_id = l_bal_valid_id;
60: --

Line 64: insert into pay_balance_validation

60: --
61: exception
62: when no_data_found then
63: --
64: insert into pay_balance_validation
65: (balance_validation_id,
66: defined_balance_id,
67: business_group_id,
68: run_balance_status,

Line 70: values ( pay_balance_validation_s.nextval,

66: defined_balance_id,
67: business_group_id,
68: run_balance_status,
69: balance_load_date)
70: values ( pay_balance_validation_s.nextval,
71: p_defined_balace_id,
72: p_business_group_id,
73: p_status,
74: g_start_date);

Line 126: l_run_bal_stat pay_balance_validation.run_balance_status%type;

122: 'BOTH')
123: = 'BOTH')
124: );
125: --
126: l_run_bal_stat pay_balance_validation.run_balance_status%type;
127: l_bus_grp pay_payroll_actions.business_group_id%type;
128: --
129: begin
130: --

Line 149: pay_balance_validation pbv

145: --
146: select nvl(pbv.run_balance_status, 'I')
147: into l_run_bal_stat
148: from pay_defined_balances pdb,
149: pay_balance_validation pbv
150: where pdb.defined_balance_id = dbrec.defined_balance_id
151: and pbv.defined_balance_id (+) = pdb.defined_balance_id
152: and pbv.business_group_id (+) = dbrec.business_group_id;
153: --

Line 173: update pay_balance_validation

169: --
170: else
171: --
172: if (p_status = 'V') then
173: update pay_balance_validation
174: set balance_load_date = g_start_date
175: where dbrec.defined_balance_id = defined_balance_id
176: and dbrec.business_group_id = business_group_id;
177: end if;

Line 197: pay_balance_validation pbv

193: --
194: select nvl(pbv.run_balance_status, 'I')
195: into l_run_bal_stat
196: from pay_defined_balances pdb,
197: pay_balance_validation pbv
198: where pdb.defined_balance_id = g_def_bal_id
199: and pbv.defined_balance_id (+) = pdb.defined_balance_id
200: and pbv.business_group_id (+) = l_bus_grp;
201: --

Line 211: update pay_balance_validation

207: else
208: --
209: if (p_status = 'V') then
210: --
211: update pay_balance_validation
212: set balance_load_date = g_start_date
213: where defined_balance_id = g_def_bal_id
214: and business_group_id = l_bus_grp;
215: --

Line 531: l_run_bal_status pay_balance_validation.run_balance_status%type;

527: and ppa.effective_date between nvl(prt.effective_start_date, ppa.effective_date)
528: and nvl(prt.effective_end_date, ppa.effective_date)
529: order by 2;
530: --
531: l_run_bal_status pay_balance_validation.run_balance_status%type;
532: l_bal_load_date pay_balance_validation.balance_load_date%type;
533: begin
534: --
535: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',10);

Line 532: l_bal_load_date pay_balance_validation.balance_load_date%type;

528: and nvl(prt.effective_end_date, ppa.effective_date)
529: order by 2;
530: --
531: l_run_bal_status pay_balance_validation.run_balance_status%type;
532: l_bal_load_date pay_balance_validation.balance_load_date%type;
533: begin
534: --
535: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',10);
536: --

Line 546: -- pay_balance_validation to identify rows to be deleted

542: --
543: if (g_proc_mode = 'INVALID') then
544: --
545: -- altered delete statement to use pay_balance_attributes rather than
546: -- pay_balance_validation to identify rows to be deleted
547: --
548: delete /*+ USE_NL(prb) INDEX(prb PAY_RUN_BALANCES_N1) */
549: from pay_run_balances prb
550: where prb.assignment_id = p_asg_id

Line 574: from pay_balance_validation pbv

570: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
571: from pay_run_balances prb
572: where prb.assignment_id = p_asg_id
573: and exists (select ''
574: from pay_balance_validation pbv
575: where pbv.defined_balance_id = prb.defined_balance_id
576: and pbv.business_group_id = p_bus_grp
577: and prb.effective_date < greatest(nvl(pbv.balance_load_date,
578: to_date('0001/01/01 00:00:00',

Line 603: from pay_balance_validation

599: select balance_load_date,
600: run_balance_status
601: into l_bal_load_date,
602: l_run_bal_status
603: from pay_balance_validation
604: where defined_balance_id = g_def_bal_id
605: and business_group_id = p_bus_grp;
606: --
607: exception

Line 743: from pay_balance_validation pbv

739: --
740: delete from pay_run_balances prb
741: where prb.payroll_action_id = p_pactid
742: and exists (select ''
743: from pay_balance_validation pbv
744: where pbv.defined_balance_id =
745: prb.defined_balance_id
746: and pbv.run_balance_status = 'P'
747: and pbv.business_group_id = p_bus_grp);

Line 847: from pay_balance_validation pbv

843: --
844: delete from pay_run_balances prb
845: where prb.payroll_action_id = p_pactid
846: and exists (select ''
847: from pay_balance_validation pbv
848: where pbv.defined_balance_id = prb.defined_balance_id
849: and pbv.run_balance_status = 'P'
850: and pbv.business_group_id = p_bus_grp);
851: else

Line 880: l_run_bal_status pay_balance_validation.run_balance_status%type;

876: procedure process_group_lvl_balances( p_pactid in number)
877: is
878: l_grp_eff_date date;
879: l_bus_grp pay_payroll_actions.business_group_id%type;
880: l_run_bal_status pay_balance_validation.run_balance_status%type;
881: l_bal_load_date pay_balance_validation.balance_load_date%type;
882: l_leg_code per_business_groups.legislation_code%type;
883: begin
884: --

Line 881: l_bal_load_date pay_balance_validation.balance_load_date%type;

877: is
878: l_grp_eff_date date;
879: l_bus_grp pay_payroll_actions.business_group_id%type;
880: l_run_bal_status pay_balance_validation.run_balance_status%type;
881: l_bal_load_date pay_balance_validation.balance_load_date%type;
882: l_leg_code per_business_groups.legislation_code%type;
883: begin
884: --
885: begin

Line 914: and exists (select /+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) / ''

910: --
911: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
912: from pay_run_balances prb
913: where prb.payroll_action_id = p_pactid
914: and exists (select /*+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) */ ''
915: from pay_balance_validation pbv
916: where pbv.defined_balance_id = prb.defined_balance_id
917: and pbv.run_balance_status = 'P'
918: and pbv.business_group_id = l_bus_grp);

Line 915: from pay_balance_validation pbv

911: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
912: from pay_run_balances prb
913: where prb.payroll_action_id = p_pactid
914: and exists (select /*+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) */ ''
915: from pay_balance_validation pbv
916: where pbv.defined_balance_id = prb.defined_balance_id
917: and pbv.run_balance_status = 'P'
918: and pbv.business_group_id = l_bus_grp);
919: --

Line 936: from pay_balance_validation pbv

932: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
933: from pay_run_balances prb
934: where prb.payroll_action_id = p_pactid
935: and exists (select ''
936: from pay_balance_validation pbv
937: where pbv.defined_balance_id = prb.defined_balance_id
938: and pbv.business_group_id = l_bus_grp
939: and prb.effective_date < greatest(nvl(pbv.balance_load_date,
940: to_date('0001/01/01 00:00:00',

Line 963: from pay_balance_validation

959: select balance_load_date,
960: run_balance_status
961: into l_bal_load_date,
962: l_run_bal_status
963: from pay_balance_validation
964: where defined_balance_id = g_def_bal_id
965: and business_group_id = l_bus_grp;
966: --
967: exception

Line 1160: from pay_balance_validation pbv

1156: )
1157: and ( p_bal_list <> 'INVALID'
1158: or ( p_bal_list = 'INVALID'
1159: and exists (select ''
1160: from pay_balance_validation pbv
1161: where pbv.defined_balance_id = pdb.defined_balance_id
1162: and pbv.business_group_id = p_bus_grp_id
1163: and pbv.run_balance_status = 'P')
1164: )

Line 1188: from pay_balance_validation pbv

1184: and pdb.balance_type_id = pbt.balance_type_id
1185: and ( p_bal_list <> 'INVALID'
1186: or ( p_bal_list = 'INVALID'
1187: and exists (select ''
1188: from pay_balance_validation pbv
1189: where pbv.defined_balance_id = pdb.defined_balance_id
1190: and pbv.business_group_id = p_bus_grp_id
1191: and pbv.run_balance_status = 'P')
1192: )