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_PURGE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 104: ,action_status pay_assignment_actions.action_status%type

100: -- Global Types
101: --
102: type t_asgact_rec is record
103: (assignment_action_id number
104: ,action_status pay_assignment_actions.action_status%type
105: ,action_sequence number
106: -- Payroll action information
107: ,payroll_action_id number
108: ,action_type pay_payroll_actions.action_type%type

Line 178: ,pay_assignment_actions act

174: ,act.assignment_id
175: ,act.end_date rollup_date
176: from
177: pay_payroll_actions pac
178: ,pay_assignment_actions act
179: where
180: act.assignment_action_id = p_assignment_action_id
181: and pac.payroll_action_id = act.payroll_action_id
182: ;

Line 327: from pay_assignment_actions

323: -- Retrieve the number of assignments to process.
324: --
325: select count(assignment_action_id)
326: into g_purge_action_rec.asg_count
327: from pay_assignment_actions
328: where payroll_action_id = p_purge_action_id
329: and action_status <> 'C';
330:
331: hr_utility.trace(' Asg Count = '||g_purge_action_rec.asg_count);

Line 434: index (purge_paa PAY_ASSIGNMENT_ACTIONS_N51)

430: --
431: select
432: /*+ ordered
433: index (prr PAY_RUN_RESULTS_N1)
434: index (purge_paa PAY_ASSIGNMENT_ACTIONS_N51)
435: use_nl (piv prr paa ppa purge_paa prrv) */
436: 1
437: from
438: pay_balance_feeds_f pbf

Line 441: ,pay_assignment_actions paa

437: from
438: pay_balance_feeds_f pbf
439: ,pay_input_values_f piv
440: ,pay_run_results prr
441: ,pay_assignment_actions paa
442: ,pay_payroll_actions ppa
443: ,pay_assignment_actions purge_paa
444: ,pay_run_result_values prrv
445: where

Line 443: ,pay_assignment_actions purge_paa

439: ,pay_input_values_f piv
440: ,pay_run_results prr
441: ,pay_assignment_actions paa
442: ,pay_payroll_actions ppa
443: ,pay_assignment_actions purge_paa
444: ,pay_run_result_values prrv
445: where
446: pbf.balance_type_id = p_baltypid
447: and pbf.effective_start_date <= p_purge_date

Line 585: pay_assignment_actions paa

581: ppa.effective_date
582: ,paa.assignment_id
583: ,paa.end_date
584: from
585: pay_assignment_actions paa
586: ,pay_payroll_actions ppa
587: where
588: paa.assignment_action_id = p_assignment_action_id
589: and ppa.payroll_action_id = paa.payroll_action_id

Line 680: update pay_assignment_actions

676: --
677: if nvl(l_act_rec.end_date, l_act_rec.effective_date)
678: <> l_act_rec.effective_date then
679: --
680: update pay_assignment_actions
681: set end_date = null
682: where assignment_action_id = p_assignment_action_id;
683: end if;
684: else

Line 695: update pay_assignment_actions

691: if csr_term_asg%found and
692: (nvl(l_act_rec.end_date, l_act_rec.effective_date) <> l_rollup_date)
693: then
694: --
695: update pay_assignment_actions
696: set end_date = l_rollup_date
697: where assignment_action_id = p_assignment_action_id;
698: end if;
699: close csr_term_asg;

Line 779: pay_assignment_actions paa,

775: ffc.context_id,
776: ffc.context_name,
777: to_char(paa.tax_unit_id)
778: from ff_contexts ffc,
779: pay_assignment_actions paa,
780: pay_payroll_actions ppa
781: where ffc.context_name = 'TAX_UNIT_ID'
782: and paa.assignment_id = p_assignment_id
783: and paa.tax_unit_id is not null

Line 802: pay_assignment_actions act,

798: select ffc.context_id,
799: ffc.context_name,
800: to_char(act.tax_unit_id) context_value
801: from ff_contexts ffc,
802: pay_assignment_actions act,
803: pay_payroll_actions pac
804: where act.assignment_id = p_assignment_id
805: and pac.payroll_action_id = act.payroll_action_id
806: and pac.effective_date <= p_purge_date

Line 815: pay_assignment_actions act,

811: ffc.context_name,
812: ctx.context_value
813: from pay_action_contexts ctx,
814: ff_contexts ffc,
815: pay_assignment_actions act,
816: pay_payroll_actions pac
817: where ctx.assignment_id = p_assignment_id
818: and ffc.context_id = ctx.context_id
819: and ffc.context_name in ('JURISDICTION_CODE',

Line 861: select /+ INDEX(act PAY_ASSIGNMENT_ACTIONS_N51) /

857: * Will return the balance initialization actions
858: * in reverse time order.
859: */
860: cursor c1 is
861: select /*+ INDEX(act PAY_ASSIGNMENT_ACTIONS_N51) */
862: distinct
863: act.rowid
864: ,act.assignment_action_id
865: ,act.action_sequence

Line 866: from pay_assignment_actions act,

862: distinct
863: act.rowid
864: ,act.assignment_action_id
865: ,act.action_sequence
866: from pay_assignment_actions act,
867: pay_balance_batch_lines bbl
868: where bbl.batch_id = p_batch_id
869: and act.payroll_action_id = bbl.payroll_action_id
870: and act.assignment_id = bbl.assignment_id

Line 885: update pay_assignment_actions act

881:
882: for c1rec in c1 loop
883: l_action_sequence := l_action_sequence - 1;
884:
885: update pay_assignment_actions act
886: set act.action_sequence = l_action_sequence
887: where act.rowid = c1rec.rowid;
888:
889: --

Line 1034: select pay_assignment_actions_s.nextval

1030: l_asgact_rec.time_period_id,
1031: 1);
1032:
1033: -- Obtain the assignment_action_id.
1034: select pay_assignment_actions_s.nextval
1035: into l_new_assactid
1036: from dual;
1037:
1038: -- Action sequence must match value for purge.

Line 1039: insert into pay_assignment_actions (

1035: into l_new_assactid
1036: from dual;
1037:
1038: -- Action sequence must match value for purge.
1039: insert into pay_assignment_actions (
1040: assignment_action_id,
1041: assignment_id,
1042: payroll_action_id,
1043: action_status,