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

Line 68: leg_param pay_payroll_actions.legislative_parameters%type;

64: ----------------------------------- range_cursor ----------------------------------
65: --
66: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
67: l_payroll_id number;
68: leg_param pay_payroll_actions.legislative_parameters%type;
69: --
70: begin
71: select legislative_parameters
72: into leg_param

Line 73: from pay_payroll_actions ppa

69: --
70: begin
71: select legislative_parameters
72: into leg_param
73: from pay_payroll_actions ppa
74: where ppa.payroll_action_id = pactid;
75:
76:
77: /* pay reg code */

Line 82: pay_payroll_actions ppa2, /* run and quickpay payroll actions */

78:
79: sqlstr := 'select distinct asg.person_id
80: from pay_assignment_actions act,
81: per_assignments_f asg,
82: pay_payroll_actions ppa2, /* run and quickpay payroll actions */
83: pay_assignment_actions act2, /* run and quickpay assignment actions */
84: pay_action_interlocks pai, /* interlocks table */
85: pay_payroll_actions ppa, /* PYUGEN information */
86: pay_payroll_actions pa1 /* Payroll Register information */

Line 85: pay_payroll_actions ppa, /* PYUGEN information */

81: per_assignments_f asg,
82: pay_payroll_actions ppa2, /* run and quickpay payroll actions */
83: pay_assignment_actions act2, /* run and quickpay assignment actions */
84: pay_action_interlocks pai, /* interlocks table */
85: pay_payroll_actions ppa, /* PYUGEN information */
86: pay_payroll_actions pa1 /* Payroll Register information */
87: where ppa.payroll_action_id = :payroll_action_id
88: and pa1.consolidation_set_id =
89: nvl(pay_payrg_pkg.get_parameter(''C_ST_ID'',ppa.legislative_parameters),pa1.consolidation_set_id)

Line 86: pay_payroll_actions pa1 /* Payroll Register information */

82: pay_payroll_actions ppa2, /* run and quickpay payroll actions */
83: pay_assignment_actions act2, /* run and quickpay assignment actions */
84: pay_action_interlocks pai, /* interlocks table */
85: pay_payroll_actions ppa, /* PYUGEN information */
86: pay_payroll_actions pa1 /* Payroll Register information */
87: where ppa.payroll_action_id = :payroll_action_id
88: and pa1.consolidation_set_id =
89: nvl(pay_payrg_pkg.get_parameter(''C_ST_ID'',ppa.legislative_parameters),pa1.consolidation_set_id)
90: and pa1.payroll_id =

Line 144: pay_payroll_actions ppa, /* pre-payments and reversals

140: ppa.effective_date,
141: act.source_action_id
142: from pay_assignment_actions act,
143: per_assignments_f paf,
144: pay_payroll_actions ppa, /* pre-payments and reversals
145: payroll action id */
146: pay_payroll_actions ppa1, /* PYUGEN payroll action id */
147: pay_all_payrolls_f ppf
148: where ppa1.payroll_action_id = pactid

Line 146: pay_payroll_actions ppa1, /* PYUGEN payroll action id */

142: from pay_assignment_actions act,
143: per_assignments_f paf,
144: pay_payroll_actions ppa, /* pre-payments and reversals
145: payroll action id */
146: pay_payroll_actions ppa1, /* PYUGEN payroll action id */
147: pay_all_payrolls_f ppf
148: where ppa1.payroll_action_id = pactid
149: and ((ppf.payroll_id = cp_payroll_id) OR
150: (cp_payroll_id is null))

Line 186: ,pay_payroll_actions ppa2

182: and ( ( ppa.action_type in ('P','U') and
183: ( exists ( select 1
184: from pay_action_interlocks pai1
185: ,pay_assignment_actions paa1
186: ,pay_payroll_actions ppa2
187: where pai1.locking_action_id = act.assignment_action_id
188: and paa1.assignment_action_id = pai1.locked_action_id
189: and ppa2.payroll_action_id = paa1.payroll_action_id
190: and ppa2.action_type <> 'V' ))) OR

Line 219: pay_payroll_actions ppa,

215:
216: cursor c_get_map_flag(cp_prepay_action_id number) is
217: select ppf.multi_assignments_flag
218: from pay_assignment_actions paa,
219: pay_payroll_actions ppa,
220: pay_all_payrolls_f ppf
221: where assignment_action_id = cp_prepay_action_id
222: and ppa.payroll_action_id = paa.payroll_action_id
223: and ppf.payroll_id = ppa.payroll_id

Line 240: ,pay_payroll_actions ppa

236: cursor c_pp_aaid_for_sepchk(cp_source_action_id number) is
237: select paa.assignment_action_id
238: from pay_action_interlocks pai
239: ,pay_assignment_actions paa
240: ,pay_payroll_actions ppa
241: where pai.locked_action_id = cp_source_action_id
242: and paa.assignment_action_id = pai.locking_action_id
243: and paa.source_action_id is not null
244: and ppa.payroll_action_id = paa.payroll_action_id

Line 255: pay_payroll_actions ppa

251: select max(paa.assignment_action_id)
252: from pay_assignment_actions paa,
253: pay_action_interlocks pai,
254: pay_run_types_f prt,
255: pay_payroll_actions ppa
256: where pai.locking_action_id = cp_prepay_action_id
257: and paa.assignment_action_id = pai.locked_action_id
258: and paa.assignment_id = cp_assignment_id
259: and paa.tax_unit_id = cp_tax_unit_id

Line 274: pay_payroll_actions ppa

270: select max(paa.assignment_action_id)
271: from pay_assignment_actions paa,
272: pay_action_interlocks pai,
273: pay_run_types_f prt,
274: pay_payroll_actions ppa
275: where pai.locking_action_id = cp_prepay_action_id
276: and paa.assignment_action_id = pai.locked_action_id
277: and paa.assignment_id = cp_assignment_id
278: and paa.run_type_id <> cp_sepchk_run_tp_id

Line 311: pay_payroll_actions ppa_run,

307: ,cp_action_sequence number) is
308: select paa_run.action_sequence, paa_run.assignment_action_id
309: from pay_action_interlocks pai,
310: pay_assignment_actions paa_run,
311: pay_payroll_actions ppa_run,
312: pay_run_types_f prt
313: where pai.locking_action_id = cp_prepay_asg_act_id
314: and paa_run.assignment_action_id = pai.locked_action_id
315: and paa_run.assignment_id = cp_assignment_id

Line 408: from pay_payroll_actions ppa

404: ln_leg_org_id,
405: ln_leg_loc_id,
406: ln_leg_person_id,
407: ln_leg_bg_id
408: from pay_payroll_actions ppa
409: where ppa.payroll_action_id = pactid;
410:
411: open c_arch_lvl(ln_busi_grp_id);
412: fetch c_arch_lvl into lv_pyrl_arch_lvl;

Line 770: pay_payroll_actions ppa1 /* PYUGEN payroll action id */

766: hr_locations_all loc,
767: per_all_people_f ppf,
768: per_all_assignments_f paf,
769: pay_assignment_actions paa1, /* PYUGEN assignment action */
770: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
771: where ppa1.payroll_action_id = :pactid
772: and paa1.payroll_action_id = ppa1.payroll_action_id
773: and paa1.assignment_id = paf.assignment_id
774: and paf.effective_start_date =

Line 812: token_val pay_payroll_actions.legislative_parameters%type;

808: parameter_list varchar2) return varchar2
809: is
810: start_ptr number;
811: end_ptr number;
812: token_val pay_payroll_actions.legislative_parameters%type;
813: par_value pay_payroll_actions.legislative_parameters%type;
814: begin
815: --
816: token_val := name||'=';

Line 813: par_value pay_payroll_actions.legislative_parameters%type;

809: is
810: start_ptr number;
811: end_ptr number;
812: token_val pay_payroll_actions.legislative_parameters%type;
813: par_value pay_payroll_actions.legislative_parameters%type;
814: begin
815: --
816: token_val := name||'=';
817: --