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 73: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

69:
70:
71: l_assign_year number;
72: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
73: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
74: begin
75:
76: /* EOY reg code */
77: /* year end pre-processor stores person id in serial number */

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

83: ppa.payroll_action_id
84: into l_tax_unit_id,
85: l_assign_year,
86: l_eoy_payroll_action_id
87: from pay_payroll_actions ppa, /* EOY payroll action id */
88: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
89: where ppa1.payroll_action_id = pactid
90: and ppa.effective_date = to_date('31-DEC-'||
91: pay_yrend_reports_pkg.get_parameter

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

84: into l_tax_unit_id,
85: l_assign_year,
86: l_eoy_payroll_action_id
87: from pay_payroll_actions ppa, /* EOY payroll action id */
88: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
89: where ppa1.payroll_action_id = pactid
90: and ppa.effective_date = to_date('31-DEC-'||
91: pay_yrend_reports_pkg.get_parameter
92: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')

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

111: stperson in number,
112: endperson in number,
113: chunk in number) is
114: -- cursor has been modified by adding new parameter c_pay_action_id and removed
115: -- the reference to pay_payroll_actions table by fetching values in a separate query.
116: --
117: -- cursor will be used when asignment_set is selected.
118:
119: CURSOR c_actions_with_asg_set

Line 127: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type

123: endperson number,
124: c_assign_year number,
125: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
126: c_assign_set hr_assignment_set_amendments.assignment_set_id%type,
127: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type
128: ) is
129: select act.assignment_action_id,
130: act.assignment_id,
131: act.tax_unit_id,

Line 157: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,

153: stperson number,
154: endperson number,
155: c_assign_year number,
156: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
157: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
158: c_effective_date pay_payroll_actions.effective_date%TYPE,
159: c_start_date pay_payroll_actions.start_date%TYPE
160: ) is
161: select act.assignment_action_id,

Line 158: c_effective_date pay_payroll_actions.effective_date%TYPE,

154: endperson number,
155: c_assign_year number,
156: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
157: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
158: c_effective_date pay_payroll_actions.effective_date%TYPE,
159: c_start_date pay_payroll_actions.start_date%TYPE
160: ) is
161: select act.assignment_action_id,
162: act.assignment_id,

Line 159: c_start_date pay_payroll_actions.start_date%TYPE

155: c_assign_year number,
156: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
157: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
158: c_effective_date pay_payroll_actions.effective_date%TYPE,
159: c_start_date pay_payroll_actions.start_date%TYPE
160: ) is
161: select act.assignment_action_id,
162: act.assignment_id,
163: act.tax_unit_id,

Line 190: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

186: p_person_id number;
187: l_assign_set number;
188: l_assign_year number;
189: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
190: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
191:
192: l_effective_date pay_payroll_actions.effective_date%TYPE;
193: l_start_date pay_payroll_actions.start_date%TYPE;
194:

Line 192: l_effective_date pay_payroll_actions.effective_date%TYPE;

188: l_assign_year number;
189: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
190: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
191:
192: l_effective_date pay_payroll_actions.effective_date%TYPE;
193: l_start_date pay_payroll_actions.start_date%TYPE;
194:
195: -- BUG2538173
196: CURSOR c_state_context (p_context_name varchar2) is

Line 193: l_start_date pay_payroll_actions.start_date%TYPE;

189: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
190: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
191:
192: l_effective_date pay_payroll_actions.effective_date%TYPE;
193: l_start_date pay_payroll_actions.start_date%TYPE;
194:
195: -- BUG2538173
196: CURSOR c_state_context (p_context_name varchar2) is
197: select context_id from ff_contexts

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

238: l_effective_date,
239: l_start_date
240: ,l_state_code -- BUG2538173
241: ,l_locality_code
242: from pay_payroll_actions ppa, /* W2 payroll action id */
243: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
244: where ppa1.payroll_action_id = pactid
245: and ppa.effective_date = to_date('31-DEC-'|| pay_yrend_reports_pkg.get_parameter
246: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')

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

239: l_start_date
240: ,l_state_code -- BUG2538173
241: ,l_locality_code
242: from pay_payroll_actions ppa, /* W2 payroll action id */
243: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
244: where ppa1.payroll_action_id = pactid
245: and ppa.effective_date = to_date('31-DEC-'|| pay_yrend_reports_pkg.get_parameter
246: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
247: and ppa.report_type = 'YREND'

Line 567: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

563: l_sort2 varchar2(60);
564: l_sort3 varchar2(60);
565: l_year_start date;
566: l_year_end date;
567: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
568: l_bg_id pay_payroll_actions.business_group_id%type ;
569:
570: begin
571: begin

Line 568: l_bg_id pay_payroll_actions.business_group_id%type ;

564: l_sort3 varchar2(60);
565: l_year_start date;
566: l_year_end date;
567: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
568: l_bg_id pay_payroll_actions.business_group_id%type ;
569:
570: begin
571: begin
572: select hr_us_w2_mt.get_parameter('YEAR',ppa1.legislative_parameters),

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

592: l_sort2,
593: l_sort3,
594: l_dt, --session_date
595: l_bg_id
596: from pay_payroll_actions ppa1 /* PYUGEN payroll action id */
597: where ppa1.payroll_action_id = payactid;
598: exception
599: when no_data_found then
600: hr_utility.trace('Error in Sort Procedure - getting legislative param');

Line 611: pay_payroll_actions ppa1,

607: hr_locations_all loc,
608: per_all_people_f ppf, -- #1894165
609: per_all_assignments_f paf,
610: /*pay_assignment_actions paa,*/
611: pay_payroll_actions ppa1,
612: pay_assignment_actions paa1 /* PYUGEN assignment action */
613: where ppa1.payroll_action_id = :pactid
614: and paa1.payroll_action_id = ppa1.payroll_action_id
615: and paf.assignment_id = paa1.assignment_id

Line 668: token_val pay_payroll_actions.legislative_parameters%type;

664: parameter_list varchar2) return varchar2
665: is
666: start_ptr number;
667: end_ptr number;
668: token_val pay_payroll_actions.legislative_parameters%type;
669: par_value pay_payroll_actions.legislative_parameters%type;
670: begin
671:
672: token_val := ' ' || name||'=';

Line 669: par_value pay_payroll_actions.legislative_parameters%type;

665: is
666: start_ptr number;
667: end_ptr number;
668: token_val pay_payroll_actions.legislative_parameters%type;
669: par_value pay_payroll_actions.legislative_parameters%type;
670: begin
671:
672: token_val := ' ' || name||'=';
673:

Line 710: from pay_payroll_actions ppa,

706: from dual
707: where exists(
708: select /*+ ORDERED */
709: null
710: from pay_payroll_actions ppa,
711: pay_us_rpt_totals purt
712: where ppa.payroll_action_id = p_payroll_action_id
713: and ppa.action_status = 'E'
714: and purt.session_id = p_payroll_action_id);