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 63: leg_param pay_payroll_actions.legislative_parameters%type;

59: ----------------------------------- range_cursor ----------------------------------
60: --
61: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
62: l_payroll_id number;
63: leg_param pay_payroll_actions.legislative_parameters%type;
64: --
65: begin
66: select legislative_parameters
67: into leg_param

Line 68: from pay_payroll_actions ppa

64: --
65: begin
66: select legislative_parameters
67: into leg_param
68: from pay_payroll_actions ppa
69: where ppa.payroll_action_id = pactid;
70:
71:
72: /* pay reg code */

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

73:
74: sqlstr := 'select distinct asg.person_id
75: from pay_assignment_actions act,
76: per_assignments_f asg,
77: pay_payroll_actions ppa2, /* run and quickpay payroll actions */
78: pay_assignment_actions act2, /* run and quickpay assignment actions */
79: pay_action_interlocks pai, /* interlocks table */
80: pay_payroll_actions ppa, /* PYUGEN information */
81: pay_payroll_actions pa1 /* Payroll Register information */

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

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

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

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

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

135: ppa.effective_date,
136: act.source_action_id
137: from pay_assignment_actions act,
138: per_assignments_f paf,
139: pay_payroll_actions ppa, /* pre-payments and reversals
140: payroll action id */
141: pay_payroll_actions ppa1, /* PYUGEN payroll action id */
142: pay_all_payrolls_f ppf
143: where ppa1.payroll_action_id = pactid

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

137: from pay_assignment_actions act,
138: per_assignments_f paf,
139: pay_payroll_actions ppa, /* pre-payments and reversals
140: payroll action id */
141: pay_payroll_actions ppa1, /* PYUGEN payroll action id */
142: pay_all_payrolls_f ppf
143: where ppa1.payroll_action_id = pactid
144: and ((ppf.payroll_id = cp_payroll_id) OR
145: (cp_payroll_id is null))

Line 181: ,pay_payroll_actions ppa2

177: and ( ( ppa.action_type in ('P','U') and
178: ( exists ( select 1
179: from pay_action_interlocks pai1
180: ,pay_assignment_actions paa1
181: ,pay_payroll_actions ppa2
182: where pai1.locking_action_id = act.assignment_action_id
183: and paa1.assignment_action_id = pai1.locked_action_id
184: and ppa2.payroll_action_id = paa1.payroll_action_id
185: and ppa2.action_type <> 'V' ))) OR

Line 214: pay_payroll_actions ppa,

210:
211: cursor c_get_map_flag(cp_prepay_action_id number) is
212: select ppf.multi_assignments_flag
213: from pay_assignment_actions paa,
214: pay_payroll_actions ppa,
215: pay_all_payrolls_f ppf
216: where assignment_action_id = cp_prepay_action_id
217: and ppa.payroll_action_id = paa.payroll_action_id
218: and ppf.payroll_id = ppa.payroll_id

Line 235: ,pay_payroll_actions ppa

231: cursor c_pp_aaid_for_sepchk(cp_source_action_id number) is
232: select paa.assignment_action_id
233: from pay_action_interlocks pai
234: ,pay_assignment_actions paa
235: ,pay_payroll_actions ppa
236: where pai.locked_action_id = cp_source_action_id
237: and paa.assignment_action_id = pai.locking_action_id
238: and paa.source_action_id is not null
239: and ppa.payroll_action_id = paa.payroll_action_id

Line 250: pay_payroll_actions ppa

246: select max(paa.assignment_action_id)
247: from pay_assignment_actions paa,
248: pay_action_interlocks pai,
249: pay_run_types_f prt,
250: pay_payroll_actions ppa
251: where pai.locking_action_id = cp_prepay_action_id
252: and paa.assignment_action_id = pai.locked_action_id
253: and paa.assignment_id = cp_assignment_id
254: and paa.tax_unit_id = cp_tax_unit_id

Line 269: pay_payroll_actions ppa

265: select max(paa.assignment_action_id)
266: from pay_assignment_actions paa,
267: pay_action_interlocks pai,
268: pay_run_types_f prt,
269: pay_payroll_actions ppa
270: where pai.locking_action_id = cp_prepay_action_id
271: and paa.assignment_action_id = pai.locked_action_id
272: and paa.assignment_id = cp_assignment_id
273: and paa.run_type_id <> cp_sepchk_run_tp_id

Line 306: pay_payroll_actions ppa_run,

302: ,cp_action_sequence number) is
303: select paa_run.action_sequence, paa_run.assignment_action_id
304: from pay_action_interlocks pai,
305: pay_assignment_actions paa_run,
306: pay_payroll_actions ppa_run,
307: pay_run_types_f prt
308: where pai.locking_action_id = cp_prepay_asg_act_id
309: and paa_run.assignment_action_id = pai.locked_action_id
310: and paa_run.assignment_id = cp_assignment_id

Line 403: from pay_payroll_actions ppa

399: ln_leg_org_id,
400: ln_leg_loc_id,
401: ln_leg_person_id,
402: ln_leg_bg_id
403: from pay_payroll_actions ppa
404: where ppa.payroll_action_id = pactid;
405:
406: open c_arch_lvl(ln_busi_grp_id);
407: fetch c_arch_lvl into lv_pyrl_arch_lvl;

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

761: hr_locations_all loc,
762: per_all_people_f ppf,
763: per_all_assignments_f paf,
764: pay_assignment_actions paa1, /* PYUGEN assignment action */
765: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
766: where ppa1.payroll_action_id = :pactid
767: and paa1.payroll_action_id = ppa1.payroll_action_id
768: and paa1.assignment_id = paf.assignment_id
769: and paf.effective_start_date =

Line 807: token_val pay_payroll_actions.legislative_parameters%type;

803: parameter_list varchar2) return varchar2
804: is
805: start_ptr number;
806: end_ptr number;
807: token_val pay_payroll_actions.legislative_parameters%type;
808: par_value pay_payroll_actions.legislative_parameters%type;
809: begin
810: --
811: token_val := name||'=';

Line 808: par_value pay_payroll_actions.legislative_parameters%type;

804: is
805: start_ptr number;
806: end_ptr number;
807: token_val pay_payroll_actions.legislative_parameters%type;
808: par_value pay_payroll_actions.legislative_parameters%type;
809: begin
810: --
811: token_val := name||'=';
812: --