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

Line 74: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,

70: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
71: /* Bug : 10254849 */
72: CURSOR get_person_id_debug
73: ( pactid number,
74: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
75: l_tax_unit_id pay_assignment_actions.tax_unit_id%type
76: ) is
77: select distinct to_number(act.serial_number),act.assignment_id
78: from pay_assignment_actions act /* W2 Register Information */

Line 88: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

84: assignment_id number;
85: num number;
86: l_assign_year number;
87: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
88: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
89: begin
90:
91: /* EOY reg code */
92: /* year end pre-processor stores person id in serial number */

Line 102: from pay_payroll_actions ppa, /* EOY payroll action id */

98: ppa.payroll_action_id
99: into l_tax_unit_id,
100: l_assign_year,
101: l_eoy_payroll_action_id
102: from pay_payroll_actions ppa, /* EOY payroll action id */
103: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
104: where ppa1.payroll_action_id = pactid
105: and ppa.effective_date = to_date('31-DEC-'||
106: pay_yrend_reports_pkg.get_parameter

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

99: into l_tax_unit_id,
100: l_assign_year,
101: l_eoy_payroll_action_id
102: from pay_payroll_actions ppa, /* EOY payroll action id */
103: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
104: where ppa1.payroll_action_id = pactid
105: and ppa.effective_date = to_date('31-DEC-'||
106: pay_yrend_reports_pkg.get_parameter
107: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')

Line 144: -- the reference to pay_payroll_actions table by fetching values in a separate query.

140: stperson in number,
141: endperson in number,
142: chunk in number) is
143: -- cursor has been modified by adding new parameter c_pay_action_id and removed
144: -- the reference to pay_payroll_actions table by fetching values in a separate query.
145: --
146: -- cursor will be used when asignment_set is selected.
147:
148: CURSOR c_actions_with_asg_set

Line 156: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type

152: endperson number,
153: c_assign_year number,
154: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
155: c_assign_set hr_assignment_set_amendments.assignment_set_id%type,
156: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type
157: ) is
158: select act.assignment_action_id,
159: act.assignment_id,
160: act.tax_unit_id,

Line 186: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,

182: stperson number,
183: endperson number,
184: c_assign_year number,
185: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
186: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
187: c_effective_date pay_payroll_actions.effective_date%TYPE,
188: c_start_date pay_payroll_actions.start_date%TYPE
189: ) is
190: select act.assignment_action_id,

Line 187: c_effective_date pay_payroll_actions.effective_date%TYPE,

183: endperson number,
184: c_assign_year number,
185: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
186: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
187: c_effective_date pay_payroll_actions.effective_date%TYPE,
188: c_start_date pay_payroll_actions.start_date%TYPE
189: ) is
190: select act.assignment_action_id,
191: act.assignment_id,

Line 188: c_start_date pay_payroll_actions.start_date%TYPE

184: c_assign_year number,
185: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
186: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
187: c_effective_date pay_payroll_actions.effective_date%TYPE,
188: c_start_date pay_payroll_actions.start_date%TYPE
189: ) is
190: select act.assignment_action_id,
191: act.assignment_id,
192: act.tax_unit_id,

Line 219: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

215: p_person_id number;
216: l_assign_set number;
217: l_assign_year number;
218: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
219: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
220:
221: l_effective_date pay_payroll_actions.effective_date%TYPE;
222: l_start_date pay_payroll_actions.start_date%TYPE;
223:

Line 221: l_effective_date pay_payroll_actions.effective_date%TYPE;

217: l_assign_year number;
218: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
219: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
220:
221: l_effective_date pay_payroll_actions.effective_date%TYPE;
222: l_start_date pay_payroll_actions.start_date%TYPE;
223:
224: -- BUG2538173
225: CURSOR c_state_context (p_context_name varchar2) is

Line 222: l_start_date pay_payroll_actions.start_date%TYPE;

218: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
219: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
220:
221: l_effective_date pay_payroll_actions.effective_date%TYPE;
222: l_start_date pay_payroll_actions.start_date%TYPE;
223:
224: -- BUG2538173
225: CURSOR c_state_context (p_context_name varchar2) is
226: select context_id from ff_contexts

Line 271: from pay_payroll_actions ppa, /* W2 payroll action id */

267: l_effective_date,
268: l_start_date
269: ,l_state_code -- BUG2538173
270: ,l_locality_code
271: from pay_payroll_actions ppa, /* W2 payroll action id */
272: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
273: where ppa1.payroll_action_id = pactid
274: and ppa.effective_date = to_date('31-DEC-'|| pay_yrend_reports_pkg.get_parameter
275: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')

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

268: l_start_date
269: ,l_state_code -- BUG2538173
270: ,l_locality_code
271: from pay_payroll_actions ppa, /* W2 payroll action id */
272: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
273: where ppa1.payroll_action_id = pactid
274: and ppa.effective_date = to_date('31-DEC-'|| pay_yrend_reports_pkg.get_parameter
275: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
276: and ppa.report_type = 'YREND'

Line 605: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

601: l_sort2 varchar2(60);
602: l_sort3 varchar2(60);
603: l_year_start date;
604: l_year_end date;
605: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
606: l_bg_id pay_payroll_actions.business_group_id%type ;
607:
608: begin
609: begin

Line 606: l_bg_id pay_payroll_actions.business_group_id%type ;

602: l_sort3 varchar2(60);
603: l_year_start date;
604: l_year_end date;
605: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
606: l_bg_id pay_payroll_actions.business_group_id%type ;
607:
608: begin
609: begin
610: select hr_us_w2_mt.get_parameter('YEAR',ppa1.legislative_parameters),

Line 634: from pay_payroll_actions ppa1 /* PYUGEN payroll action id */

630: l_sort2,
631: l_sort3,
632: l_dt, --session_date
633: l_bg_id
634: from pay_payroll_actions ppa1 /* PYUGEN payroll action id */
635: where ppa1.payroll_action_id = payactid;
636: exception
637: when no_data_found then
638: hr_utility.trace('Error in Sort Procedure - getting legislative param');

Line 649: pay_payroll_actions ppa1,

645: hr_locations_all loc,
646: per_all_people_f ppf, -- #1894165
647: per_all_assignments_f paf,
648: /*pay_assignment_actions paa,*/
649: pay_payroll_actions ppa1,
650: pay_assignment_actions paa1 /* PYUGEN assignment action */
651: where ppa1.payroll_action_id = :pactid
652: and paa1.payroll_action_id = ppa1.payroll_action_id
653: and paf.assignment_id = paa1.assignment_id

Line 706: token_val pay_payroll_actions.legislative_parameters%type;

702: parameter_list varchar2) return varchar2
703: is
704: start_ptr number;
705: end_ptr number;
706: token_val pay_payroll_actions.legislative_parameters%type;
707: par_value pay_payroll_actions.legislative_parameters%type;
708: begin
709:
710: token_val := ' ' || name||'=';

Line 707: par_value pay_payroll_actions.legislative_parameters%type;

703: is
704: start_ptr number;
705: end_ptr number;
706: token_val pay_payroll_actions.legislative_parameters%type;
707: par_value pay_payroll_actions.legislative_parameters%type;
708: begin
709:
710: token_val := ' ' || name||'=';
711:

Line 748: from pay_payroll_actions ppa,

744: from dual
745: where exists(
746: select /*+ ORDERED */
747: null
748: from pay_payroll_actions ppa,
749: pay_us_rpt_totals purt
750: where ppa.payroll_action_id = p_payroll_action_id
751: and ppa.action_status = 'E'
752: and purt.session_id = p_payroll_action_id);