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.HRASSACT dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 75: pay_assignment_latest_balances

71: per_all_assignment_f and
72: per_periods_of_service.
73: 10-Oct-2008 salogana 115.143 7371362 Added bulk delete in
74: trash_latest_balances FOR
75: pay_assignment_latest_balances
76: 05-Aug-2008 salogana 115.142 6595092 Added bulk delete code in
77: trash_latest_balances for
78: performance improvement.
79: 26-Feb-2008 Ckesanap 115.141 6820127 Added another definition of

Line 762: -- from pay_assignment_latest_balances

758: where source_type = 'A'
759: and source_id = p_assact_id)
760: -- or exists -- check for any latest balances
761: -- (select null
762: -- from pay_assignment_latest_balances
763: -- where assignment_action_id = p_assact_id)
764: -- or exists -- check for any latest balances
765: -- (select null
766: -- from pay_person_latest_balances

Line 791: -- from pay_assignment_latest_balances

787: where source_type = 'A'
788: and source_id = p_assact_id)
789: -- or exists -- check for any latest balances
790: -- (select null
791: -- from pay_assignment_latest_balances
792: -- where assignment_action_id = p_assact_id)
793: -- or exists -- check for any latest balances
794: -- (select null
795: -- from pay_person_latest_balances

Line 1657: from pay_assignment_latest_balances ALB

1653: end if;
1654: delete from pay_balance_context_values VAL
1655: where exists (
1656: select null
1657: from pay_assignment_latest_balances ALB
1658: where ALB.assignment_action_id = p_assact_rec.assact_id
1659: and VAL.latest_balance_id = ALB.latest_balance_id);
1660: --
1661: if g_debug then

Line 1664: delete from pay_assignment_latest_balances ALB

1660: --
1661: if g_debug then
1662: hr_utility.set_location('hrassact.do_assact_rollback',40);
1663: end if;
1664: delete from pay_assignment_latest_balances ALB
1665: where ALB.assignment_action_id = p_assact_rec.assact_id;
1666: --
1667: -- If the payroll action that is being deleted is
1668: -- a Balance Adjustment (type = 'B'), then we attempt to

Line 2417: pay_assignment_latest_balances plb

2413: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2414: USE_NL (PLB) */
2415: plb.latest_balance_id
2416: from pay_defined_balances pdb,
2417: pay_assignment_latest_balances plb
2418: where pdb.balance_type_id = l_balance_type_id
2419: and plb.defined_balance_id = pdb.defined_balance_id
2420: and exists (
2421: select null

Line 2444: pay_assignment_latest_balances plb

2440: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2441: USE_NL (PLB) */
2442: plb.latest_balance_id
2443: from pay_defined_balances pdb,
2444: pay_assignment_latest_balances plb
2445: where pdb.balance_type_id = l_balance_type_id
2446: and plb.defined_balance_id = pdb.defined_balance_id;
2447: --
2448: -- Select all latest balances to delete.

Line 2472: from pay_assignment_latest_balances alb,

2468: --
2469: -- Select the balances that are PL/SQL fed.
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

Line 2504: Type t_latbal is table of pay_assignment_latest_balances.latest_balance_id%type;

2500:
2501: l_ivchk varchar2(2);
2502: l_rrv_found number := -1;
2503: --Added following type for Bug:6595092 bulk delete
2504: Type t_latbal is table of pay_assignment_latest_balances.latest_balance_id%type;
2505: lat_bal_list t_latbal;
2506: --
2507: begin
2508: g_debug := hr_utility.debug_enabled;

Line 2573: delete from pay_assignment_latest_balances ALB

2569: /* for albcrec in alatbalc loop
2570: delete from pay_balance_context_values BCV
2571: where BCV.latest_balance_id = albcrec.latest_balance_id;
2572: --
2573: delete from pay_assignment_latest_balances ALB
2574: where ALB.latest_balance_id = albcrec.latest_balance_id;
2575: end loop; */
2576:
2577: open alatbalc;

Line 2586: delete from pay_assignment_latest_balances ALB

2582: delete from pay_balance_context_values BCV
2583: where BCV.latest_balance_id = lat_bal_list(i);
2584:
2585: forall i in 1..lat_bal_list.count
2586: delete from pay_assignment_latest_balances ALB
2587: where ALB.latest_balance_id =lat_bal_list(i);
2588:
2589: exit when alatbalc%notfound;
2590: end loop;

Line 2667: delete from pay_assignment_latest_balances ALB

2663: if l_rrv_found = 1 then
2664: delete from pay_balance_context_values BCV
2665: where BCV.latest_balance_id = albcrec.latest_balance_id;
2666: --
2667: delete from pay_assignment_latest_balances ALB
2668: where ALB.latest_balance_id = albcrec.latest_balance_id;
2669: end if;
2670: end loop;
2671: end if;

Line 2727: delete from pay_assignment_latest_balances ALB

2723: delete from pay_balance_context_values BCV
2724: where BCV.latest_balance_id = lat_bal_list(i);
2725:
2726: forall i in 1..lat_bal_list.count
2727: delete from pay_assignment_latest_balances ALB
2728: where ALB.latest_balance_id =lat_bal_list(i);
2729:
2730: exit when albc%notfound;
2731: end loop;

Line 2782: delete from pay_assignment_latest_balances ALB

2778: delete from pay_balance_context_values BCV
2779: where BCV.latest_balance_id = lat_bal_list(i);
2780:
2781: forall i in 1..lat_bal_list.count
2782: delete from pay_assignment_latest_balances ALB
2783: where ALB.latest_balance_id =lat_bal_list(i);
2784:
2785: exit when pl_feed_chk_a%notfound;
2786: end loop;

Line 2837: pay_assignment_latest_balances plb

2833: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2834: USE_NL (PLB) */
2835: plb.latest_balance_id
2836: from pay_defined_balances pdb,
2837: pay_assignment_latest_balances plb
2838: where pdb.balance_type_id = l_balance_type_id
2839: and plb.defined_balance_id = pdb.defined_balance_id;
2840: -- Select all latest balances to delete.
2841: cursor lbc is

Line 2850: Type t_latbal is table of pay_assignment_latest_balances.latest_balance_id%type;

2846: pay_latest_balances lb
2847: where pdb.balance_type_id = l_balance_type_id
2848: and lb.defined_balance_id = pdb.defined_balance_id;
2849:
2850: Type t_latbal is table of pay_assignment_latest_balances.latest_balance_id%type;
2851: lat_bal_list t_latbal;
2852:
2853: begin
2854: hr_utility.set_location('hrassact.trash_latest_balances',10);

Line 2878: delete from pay_assignment_latest_balances ALB

2874: delete from pay_balance_context_values BCV
2875: where BCV.latest_balance_id = lat_bal_list(i);
2876:
2877: forall i in 1..lat_bal_list.count
2878: delete from pay_assignment_latest_balances ALB
2879: where ALB.latest_balance_id =lat_bal_list(i);
2880:
2881: exit when albc%notfound;
2882: end loop;

Line 2931: pay_assignment_latest_balances alb

2927: from per_periods_of_service pos,
2928: per_all_assignments_f asg,
2929: pay_assignment_actions act,
2930: pay_payroll_actions pac,
2931: pay_assignment_latest_balances alb
2932: where pos.person_id = p_person_id
2933: and asg.period_of_service_id = pos.period_of_service_id
2934: and asg.person_id = p_person_id
2935: and act.assignment_id = asg.assignment_id

Line 2973: from pay_assignment_latest_balances alb,

2969: cursor albc_selective (p_person_id number,
2970: p_eletyp_id number) is
2971: select
2972: alb.latest_balance_id
2973: from pay_assignment_latest_balances alb,
2974: pay_assignment_actions act,
2975: pay_payroll_actions pac,
2976: pay_defined_balances pdb,
2977: pay_balance_feeds_f pbf,

Line 3057: delete from pay_assignment_latest_balances ALB

3053: for albcrec in albc(l_person_id) loop
3054: delete from pay_balance_context_values BCV
3055: where BCV.latest_balance_id = albcrec.latest_balance_id;
3056: --
3057: delete from pay_assignment_latest_balances ALB
3058: where ALB.latest_balance_id = albcrec.latest_balance_id;
3059: end loop;
3060: --
3061: if g_debug then

Line 3115: delete from pay_assignment_latest_balances ALB

3111: for albcrec in albc_selective(l_person_id, l_element_type_id) loop
3112: delete from pay_balance_context_values BCV
3113: where BCV.latest_balance_id = albcrec.latest_balance_id;
3114: --
3115: delete from pay_assignment_latest_balances ALB
3116: where ALB.latest_balance_id = albcrec.latest_balance_id;
3117: end loop;
3118: --
3119: if g_debug then

Line 7092: from pay_assignment_latest_balances palb,

7088: nvl(palb.prev_assignment_action_id, -9999) prev_assignment_action_id,
7089: pdb.balance_dimension_id,
7090: pdb.balance_type_id,
7091: pbf.scale
7092: from pay_assignment_latest_balances palb,
7093: pay_defined_balances pdb,
7094: pay_balance_feeds_f pbf
7095: where pbf.input_value_id = p_inp_val_id
7096: and effdate between pbf.effective_start_date

Line 7791: delete from pay_assignment_latest_balances

7787: if lat_bal_type = 'A' then
7788: delete from pay_balance_context_values
7789: where latest_balance_id = lat_bal_id;
7790:
7791: delete from pay_assignment_latest_balances
7792: where latest_balance_id = lat_bal_id;
7793: elsif lat_bal_type = 'P' then
7794: delete from pay_balance_context_values
7795: where latest_balance_id = lat_bal_id;

Line 8518: update pay_assignment_latest_balances

8514: fnd_number.canonical_to_number(rrv.result_value),
8515: alb.scale, dummy_date,dummy_date,dummy_date);
8516:
8517: if l_change_flag = TRUE then
8518: update pay_assignment_latest_balances
8519: set assignment_action_id = alb.assignment_action_id,
8520: value = alb.value,
8521: expired_assignment_action_id = alb.expired_assignment_action_id,
8522: expired_value = alb.expired_value,