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

Line 12: leg_param pay_payroll_actions.legislative_parameters%TYPE ;

8: -- ---------------------------------------------------------------------
9: PROCEDURE range_cursor
10: (pactid IN NUMBER
11: ,sqlstr OUT NOCOPY VARCHAR2) IS
12: leg_param pay_payroll_actions.legislative_parameters%TYPE ;
13: l_consolidation_set_id NUMBER;
14: l_payroll_id NUMBER;
15: l_tax_unit_id NUMBER;
16: l_proc_name VARCHAR2(150) := g_proc_name ||'range_cursor';

Line 31: FROM pay_payroll_actions ppa

27: INTO leg_param,
28: l_consolidation_set_id,
29: l_payroll_id,
30: l_tax_unit_id
31: FROM pay_payroll_actions ppa
32: WHERE ppa.payroll_action_id = pactid;
33: hr_utility.set_location('..Parameters are :'||leg_param,15);
34:
35: -- For Bug 5636004 Performance Improvement.

Line 59: pay_payroll_actions ppa_run,

55:
56: sqlstr := 'select distinct asg.person_id
57: from per_assignments_f asg,
58: pay_assignment_actions act_run,
59: pay_payroll_actions ppa_run,
60: pay_payroll_actions ppa_gen
61: where ppa_gen.payroll_action_id = :payroll_action_id
62: and ppa_run.action_type in (''R'',''Q'',''V'',''B'')
63: and ppa_run.action_status = ''C''

Line 60: pay_payroll_actions ppa_gen

56: sqlstr := 'select distinct asg.person_id
57: from per_assignments_f asg,
58: pay_assignment_actions act_run,
59: pay_payroll_actions ppa_run,
60: pay_payroll_actions ppa_gen
61: where ppa_gen.payroll_action_id = :payroll_action_id
62: and ppa_run.action_type in (''R'',''Q'',''V'',''B'')
63: and ppa_run.action_status = ''C''
64: '||l_consolidation_set_text||'

Line 92: leg_param pay_payroll_actions.legislative_parameters%TYPE;

88: stperson IN NUMBER ,
89: endperson IN NUMBER,
90: chunk IN NUMBER) IS
91:
92: leg_param pay_payroll_actions.legislative_parameters%TYPE;
93: l_consolidation_set_id NUMBER;
94: l_payroll_id NUMBER;
95: l_tax_unit_id NUMBER;
96: l_proc_name VARCHAR2(150) := g_proc_name ||'action_creation';

Line 103: FROM pay_payroll_actions ppa

99: SELECT ppa.legislative_parameters,
100: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
101: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
102: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
103: FROM pay_payroll_actions ppa
104: WHERE ppa.payroll_action_id = pactid;
105:
106: CURSOR c_actions (pactid NUMBER,
107: stperson NUMBER,

Line 115: pay_payroll_actions ppa_run,

111: act_run.assignment_action_id,
112: asg.assignment_id ,
113: act_run.tax_unit_id
114: FROM per_assignments_f asg,
115: pay_payroll_actions ppa_run,
116: pay_assignment_actions act_run,
117: pay_payroll_actions ppa_gen
118: WHERE
119: ppa_gen.payroll_action_id = pactid

Line 117: pay_payroll_actions ppa_gen

113: act_run.tax_unit_id
114: FROM per_assignments_f asg,
115: pay_payroll_actions ppa_run,
116: pay_assignment_actions act_run,
117: pay_payroll_actions ppa_gen
118: WHERE
119: ppa_gen.payroll_action_id = pactid
120: AND ppa_run.effective_date BETWEEN ppa_gen.start_date
121: AND ppa_gen.effective_date

Line 256: pay_payroll_actions ppa1

252: BEGIN
253: hr_utility.set_location('Entering : '||l_proc_name, 10);
254: sqlstr := 'select paa1.rowid
255: from pay_assignment_actions paa1,
256: pay_payroll_actions ppa1
257: where ppa1.payroll_action_id = :pactid
258: and paa1.payroll_action_id = ppa1.payroll_action_id
259: order by paa1.assignment_id,paa1.assignment_action_id
260: for update of paa1.assignment_id';

Line 282: token_val pay_payroll_actions.legislative_parameters%TYPE;

278: parameter_list VARCHAR2
279: ) RETURN VARCHAR2 IS
280: start_ptr NUMBER;
281: end_ptr NUMBER;
282: token_val pay_payroll_actions.legislative_parameters%TYPE;
283: par_value pay_payroll_actions.legislative_parameters%TYPE;
284:
285: BEGIN
286: token_val := name||'=';

Line 283: par_value pay_payroll_actions.legislative_parameters%TYPE;

279: ) RETURN VARCHAR2 IS
280: start_ptr NUMBER;
281: end_ptr NUMBER;
282: token_val pay_payroll_actions.legislative_parameters%TYPE;
283: par_value pay_payroll_actions.legislative_parameters%TYPE;
284:
285: BEGIN
286: token_val := name||'=';
287: start_ptr := INSTR(parameter_list, token_val) + LENGTH(token_val);

Line 309: leg_param pay_payroll_actions.legislative_parameters%TYPE;

305: stperson IN NUMBER ,
306: endperson IN NUMBER,
307: chunk IN NUMBER) IS
308:
309: leg_param pay_payroll_actions.legislative_parameters%TYPE;
310: l_consolidation_set_id NUMBER;
311: l_payroll_id NUMBER;
312: l_tax_unit_id NUMBER;
313: l_proc_name VARCHAR2(150) := g_proc_name ||'action_creation_ops';

Line 320: FROM pay_payroll_actions ppa

316: SELECT ppa.legislative_parameters,
317: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
318: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
319: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
320: FROM pay_payroll_actions ppa
321: WHERE ppa.payroll_action_id = pactid;
322:
323: CURSOR c_actions_ops (pactid NUMBER,
324: stperson NUMBER,

Line 330: pay_payroll_actions ppa_run,

326: SELECT
327: max(act_run.assignment_action_id),
328: asg.assignment_id
329: FROM per_assignments_f asg,
330: pay_payroll_actions ppa_run,
331: pay_assignment_actions act_run,
332: pay_payroll_actions ppa_gen
333: WHERE
334: ppa_gen.payroll_action_id = pactid

Line 332: pay_payroll_actions ppa_gen

328: asg.assignment_id
329: FROM per_assignments_f asg,
330: pay_payroll_actions ppa_run,
331: pay_assignment_actions act_run,
332: pay_payroll_actions ppa_gen
333: WHERE
334: ppa_gen.payroll_action_id = pactid
335: AND ppa_run.effective_date BETWEEN ppa_gen.start_date
336: AND ppa_gen.effective_date

Line 684: pay_payroll_actions ppa

680: select ppa.start_date,
681: ppa.effective_date,
682: bg.name
683: from per_business_groups bg,
684: pay_payroll_actions ppa
685: where ppa.payroll_action_id = pactid
686: and ppa.business_group_id = bg.business_group_id;
687:
688: l_payroll_action_id number;

Line 785: leg_param pay_payroll_actions.legislative_parameters%TYPE;

781: l_assignment_action_id number;
782: l_locked_act_id number;
783: l_err_msg varchar2(1000);
784: l_err boolean := FALSE;
785: leg_param pay_payroll_actions.legislative_parameters%TYPE;
786: l_consolidation_set_id NUMBER;
787:
788: CURSOR csr_per_detail (p_asg_id number,
789: p_date date) IS

Line 833: from pay_payroll_actions ppa_gen,

829: select paa.assignment_id asg_id,
830: paa.assignment_action_id act_id,
831: ppa_run.effective_date pay_date,
832: paa.tax_unit_id tax_unit_id
833: from pay_payroll_actions ppa_gen,
834: pay_assignment_actions paa,
835: pay_payroll_actions ppa_run,
836: pay_temp_object_actions poa
837: where poa.object_action_id = p_assactid

Line 835: pay_payroll_actions ppa_run,

831: ppa_run.effective_date pay_date,
832: paa.tax_unit_id tax_unit_id
833: from pay_payroll_actions ppa_gen,
834: pay_assignment_actions paa,
835: pay_payroll_actions ppa_run,
836: pay_temp_object_actions poa
837: where poa.object_action_id = p_assactid
838: and poa.payroll_action_id = ppa_gen.payroll_action_id
839: and poa.object_id = paa.assignment_id

Line 904: FROM pay_payroll_actions ppa,

900: SELECT ppa.legislative_parameters,
901: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
902: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
903: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
904: FROM pay_payroll_actions ppa,
905: pay_temp_object_actions poa
906: WHERE poa.object_action_id = asg_actid
907: and ppa.payroll_action_id = poa.payroll_action_id;
908: