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: CURSOR c_actions

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

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

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

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

Line 233: pay_payroll_actions ppa1 -- PYUGEN payroll action id

229: BEGIN
230:
231: sqlstr := 'select paa1.rowid
232: from pay_assignment_actions paa1, -- PYUGEN assignment action
233: pay_payroll_actions ppa1 -- PYUGEN payroll action id
234: where ppa1.payroll_action_id = :pactid
235: and paa1.payroll_action_id = ppa1.payroll_action_id
236: order by paa1.assignment_action_id for update of paa1.assignment_id';
237:

Line 255: token_val pay_payroll_actions.legislative_parameters%type;

251: parameter_list varchar2) return varchar2
252: is
253: start_ptr number;
254: end_ptr number;
255: token_val pay_payroll_actions.legislative_parameters%type;
256: par_value pay_payroll_actions.legislative_parameters%type;
257: BEGIN
258: --
259: token_val := name||'=';

Line 256: par_value pay_payroll_actions.legislative_parameters%type;

252: is
253: start_ptr number;
254: end_ptr number;
255: token_val pay_payroll_actions.legislative_parameters%type;
256: par_value pay_payroll_actions.legislative_parameters%type;
257: BEGIN
258: --
259: token_val := name||'=';
260: --

Line 293: from pay_payroll_actions ppa

289: select
290: pay_core_utils.get_parameter('REMOVE_ACT',
291: ppa.legislative_parameters)
292: into l_remove_act
293: from pay_payroll_actions ppa
294: where ppa.payroll_action_id = pactid;
295:
296: --
297: if (l_remove_act is null or l_remove_act = 'Y') then