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.PQP_EXPPREPROC_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 14: leg_param pay_payroll_actions.legislative_parameters%TYPE ;

10: ----------------------------------- range_cursor ----------------------------------
11: --
12: PROCEDURE range_cursor (pactid in number, sqlstr out nocopy varchar2) IS
13:
14: leg_param pay_payroll_actions.legislative_parameters%TYPE ;
15: l_consolidation_set_id NUMBER ;
16: l_payroll_id NUMBER ;
17: l_tax_unit_id NUMBER ;
18: l_report_id NUMBER;

Line 39: FROM pay_payroll_actions ppa

35: l_tax_unit_id,
36: l_report_id ,
37: l_group_name,
38: l_start_date
39: FROM pay_payroll_actions ppa
40: WHERE ppa.payroll_action_id = pactid;
41: l_temp_date:=to_date(l_start_date,'YYYY/MM/DD');
42:
43: pqp_expreplod_pkg.upd_payroll_actions (pactid ,

Line 51: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */

47:
48: sqlstr := 'select distinct asg.person_id
49: from per_assignments_f asg,
50: pay_assignment_actions act_run, /* run and quickpay assignment actions */
51: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
52: pay_payroll_actions ppa_gen /* PYUGEN information */
53: where ppa_gen.payroll_action_id = :payroll_action_id
54: and ppa_run.action_type in (''R'',''Q'',''V'')
55: and ppa_run.action_status = ''C''

Line 52: pay_payroll_actions ppa_gen /* PYUGEN information */

48: sqlstr := 'select distinct asg.person_id
49: from per_assignments_f asg,
50: pay_assignment_actions act_run, /* run and quickpay assignment actions */
51: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
52: pay_payroll_actions ppa_gen /* PYUGEN information */
53: where ppa_gen.payroll_action_id = :payroll_action_id
54: and ppa_run.action_type in (''R'',''Q'',''V'')
55: and ppa_run.action_status = ''C''
56: and ppa_run.consolidation_set_id = nvl('''||l_consolidation_set_id||''',

Line 84: leg_param pay_payroll_actions.legislative_parameters%TYPE;

80: stperson in number ,
81: endperson in number,
82: chunk in number) IS
83:
84: leg_param pay_payroll_actions.legislative_parameters%TYPE;
85: l_consolidation_set_id NUMBER;
86: l_payroll_id NUMBER;
87: l_tax_unit_id NUMBER;
88: l_act_date VARCHAR2(15);

Line 100: FROM pay_payroll_actions ppa

96: pqp_exppreproc_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
97: pqp_exppreproc_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters) ,
98: pqp_exppreproc_pkg.get_parameter('TRANSFER_DATE',ppa.legislative_parameters),
99: pqp_exppreproc_pkg.get_parameter('TRANSFER_JD',ppa.legislative_parameters)
100: FROM pay_payroll_actions ppa
101: WHERE ppa.payroll_action_id =pactid;
102:
103:
104: /* Bug 13955510: CA localization supports mulit GRE. Modified this cursor to

Line 117: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */

113: SELECT
114: MAX(act_run.assignment_action_id),
115: asg.assignment_id
116: FROM per_assignments_f asg,
117: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
118: pay_assignment_actions act_run, /* run and quickpay assignment actions */
119: pay_payroll_actions ppa_gen, /* PYUGEN information */
120: per_time_periods ptp
121: WHERE ppa_gen.payroll_action_id = pactid

Line 119: pay_payroll_actions ppa_gen, /* PYUGEN information */

115: asg.assignment_id
116: FROM per_assignments_f asg,
117: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
118: pay_assignment_actions act_run, /* run and quickpay assignment actions */
119: pay_payroll_actions ppa_gen, /* PYUGEN information */
120: per_time_periods ptp
121: WHERE ppa_gen.payroll_action_id = pactid
122: --Added by Gattu
123: AND ptp.payroll_id = nvl(l_payroll_id,

Line 180: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */

176: SELECT /*+ LEADING(ppa_gen ppa_run ptp asg act_run) */
177: MAX(act_run.assignment_action_id),
178: asg.assignment_id
179: FROM per_assignments_f asg,
180: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
181: pay_assignment_actions act_run, /* run and quickpay assignment actions */
182: pay_payroll_actions ppa_gen, /* PYUGEN information */
183: per_time_periods ptp
184: WHERE ppa_gen.payroll_action_id = pactid

Line 182: pay_payroll_actions ppa_gen, /* PYUGEN information */

178: asg.assignment_id
179: FROM per_assignments_f asg,
180: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
181: pay_assignment_actions act_run, /* run and quickpay assignment actions */
182: pay_payroll_actions ppa_gen, /* PYUGEN information */
183: per_time_periods ptp
184: WHERE ppa_gen.payroll_action_id = pactid
185: --Added by Gattu
186: AND ptp.payroll_id = l_payroll_id

Line 322: pay_payroll_actions ppa1 -- PYUGEN payroll action id

318: BEGIN
319:
320: sqlstr := 'select paa1.rowid
321: from pay_assignment_actions paa1, -- PYUGEN assignment action
322: pay_payroll_actions ppa1 -- PYUGEN payroll action id
323: where ppa1.payroll_action_id = :pactid
324: and paa1.payroll_action_id = ppa1.payroll_action_id
325: order by paa1.assignment_action_id for update of paa1.assignment_id';
326:

Line 344: token_val pay_payroll_actions.legislative_parameters%type;

340: parameter_list varchar2) return varchar2
341: is
342: start_ptr number;
343: end_ptr number;
344: token_val pay_payroll_actions.legislative_parameters%type;
345: par_value pay_payroll_actions.legislative_parameters%type;
346: BEGIN
347: --
348: token_val := name||'=';

Line 345: par_value pay_payroll_actions.legislative_parameters%type;

341: is
342: start_ptr number;
343: end_ptr number;
344: token_val pay_payroll_actions.legislative_parameters%type;
345: par_value pay_payroll_actions.legislative_parameters%type;
346: BEGIN
347: --
348: token_val := name||'=';
349: --

Line 382: from pay_payroll_actions ppa

378: select
379: pay_core_utils.get_parameter('REMOVE_ACT',
380: ppa.legislative_parameters)
381: into l_remove_act
382: from pay_payroll_actions ppa
383: where ppa.payroll_action_id = pactid;
384:
385: --
386: if (l_remove_act is null or l_remove_act = 'Y') then