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_IE_PAYROLL_ACTIONS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 48: pay_payroll_actions ppa,

44: rpaa.payroll_action_id,
45: rpaa.assignment_action_id,
46: paa.assignment_action_id
47: from pay_assignment_actions paa,
48: pay_payroll_actions ppa,
49: pay_assignment_actions rpaa,
50: pay_payroll_actions rppa
51: where paa.payroll_action_id = ppa.payroll_action_id
52: and rppa.payroll_action_id = rpaa.payroll_action_id

Line 50: pay_payroll_actions rppa

46: paa.assignment_action_id
47: from pay_assignment_actions paa,
48: pay_payroll_actions ppa,
49: pay_assignment_actions rpaa,
50: pay_payroll_actions rppa
51: where paa.payroll_action_id = ppa.payroll_action_id
52: and rppa.payroll_action_id = rpaa.payroll_action_id
53: and paa.assignment_action_id =
54: (select

Line 56: from pay_payroll_actions pa,

52: and rppa.payroll_action_id = rpaa.payroll_action_id
53: and paa.assignment_action_id =
54: (select
55: to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
56: from pay_payroll_actions pa,
57: pay_assignment_actions aa
58: where pa.action_type in ('U','P')
59: and aa.action_status = 'C'
60: and pa.payroll_action_id = aa.payroll_action_id

Line 82: pay_payroll_actions ppa,

78: rpaa.payroll_action_id,
79: rpaa.assignment_action_id,
80: paa.assignment_action_id
81: from pay_assignment_actions paa,
82: pay_payroll_actions ppa,
83: pay_assignment_actions rpaa,
84: pay_payroll_actions rppa
85: where paa.payroll_action_id = ppa.payroll_action_id
86: and rppa.payroll_action_id = rpaa.payroll_action_id

Line 84: pay_payroll_actions rppa

80: paa.assignment_action_id
81: from pay_assignment_actions paa,
82: pay_payroll_actions ppa,
83: pay_assignment_actions rpaa,
84: pay_payroll_actions rppa
85: where paa.payroll_action_id = ppa.payroll_action_id
86: and rppa.payroll_action_id = rpaa.payroll_action_id
87: and paa.assignment_action_id = curvar2
88: and ppa.action_type in ('P', 'U')

Line 111: pay_payroll_actions rppa

107: cursor cur_pact_details(curvar3 number) IS
108: select to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
109: rpaa.payroll_action_id
110: from pay_assignment_actions rpaa,
111: pay_payroll_actions rppa
112: where rpaa.payroll_action_id = rppa.payroll_action_id
113: and rpaa.assignment_action_id = curvar3;
114:
115:

Line 124: from pay_payroll_actions pa,

120: ---before the date on which the payroll was run.It will display run results corresponding to prev.Payroll Run
121: ---in this case
122: cursor cur_assignment_action_id is
123: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
124: from pay_payroll_actions pa,
125: pay_assignment_actions aa
126: /*3922415- per_time_periods ptp */
127: where pa.action_type in ('Q','R','P','U')
128: and aa.action_status = 'C'

Line 141: from pay_payroll_actions,pay_assignment_actions

137: ---This is used to retrive the actio_type corresponding to the assignment action id found by prev cursor
138:
139: cursor cur_action_type(curvar3 number) is
140: select distinct action_type
141: from pay_payroll_actions,pay_assignment_actions
142: where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id
143: and assignment_action_id =curvar3;
144:
145:

Line 142: where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id

138:
139: cursor cur_action_type(curvar3 number) is
140: select distinct action_type
141: from pay_payroll_actions,pay_assignment_actions
142: where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id
143: and assignment_action_id =curvar3;
144:
145:
146:

Line 163: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

159: --
160: l_payroll_exists VARCHAR2(30);
161: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
162: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
163: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
164: l_date_earned VARCHAR2(30);
165: l_end_date date;
166: l_action_type varchar2(2);
167: --

Line 271: pay_payroll_actions pact

267: cursor csr_formula is
268: -- find what type of action this is
269: select pact.action_type , assact.assignment_id
270: from pay_assignment_actions assact,
271: pay_payroll_actions pact
272: where assact.assignment_action_id = p_assignment_action_id
273: and pact.payroll_action_id = assact.payroll_action_id;
274: cursor csr_formula_2 is
275: -- for prepayment action find the latest interlocked run

Line 288: pay_payroll_actions pact,

284: cursor csr_formula_3 is
285: -- for run action check if its been prepaid
286: select assact.assignment_action_id
287: from pay_assignment_actions assact,
288: pay_payroll_actions pact,
289: pay_action_interlocks loc
290: where loc.locked_action_id = p_assignment_action_id
291: and assact.assignment_action_id = loc.locking_action_id
292: and pact.payroll_action_id = assact.payroll_action_id