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.HR_US_W2_MT dependencies on PAY_PAYROLL_ACTIONS

Line 67: pay_payroll_actions ppa_arch and

63: > l_dt
64:
65: 115.15 10-Jan-02 kthirmiy For TAR 1874418.995 to improve performance changed in
66: sort_action function . Removed the tables
67: pay_payroll_actions ppa_arch and
68: pay_assignment_actions and to go directly to
69: pay_assignment_actions mt table.
70: 115.16 18-JAN-02 meshah changed the sort cursor again. Need to fetch
71: zip code for the live address.

Line 168: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

164:
165: ----------------------------------- range_cursor -------------------------------
166: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
167:
168: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
169:
170: l_business_group_id pay_payroll_actions.business_group_id%type;
171:
172: l_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;

Line 170: l_business_group_id pay_payroll_actions.business_group_id%type;

166: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
167:
168: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
169:
170: l_business_group_id pay_payroll_actions.business_group_id%type;
171:
172: l_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;
173: l_error_mesg varchar2(100);
174: l_year number ;

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

186: into l_eoy_payroll_action_id
187: ,l_business_group_id
188: ,l_year
189: ,l_report_type
190: from pay_payroll_actions ppa, /* EOY payroll action id */
191: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
192: where ppa1.payroll_action_id = pactid
193: and ppa.effective_date = ppa1.effective_date
194: and ppa.report_type = 'YREND'

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

187: ,l_business_group_id
188: ,l_year
189: ,l_report_type
190: from pay_payroll_actions ppa, /* EOY payroll action id */
191: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
192: where ppa1.payroll_action_id = pactid
193: and ppa.effective_date = ppa1.effective_date
194: and ppa.report_type = 'YREND'
195: and hr_us_w2_mt.get_parameter

Line 311: p_eoy_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

307: p_ssn in varchar2,
308: p_state_code in pay_us_states.state_code%type,
309: p_asg_set_id in number,
310: p_session_date in date,
311: p_eoy_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
312: p_eoy_start_date in date,
313: p_report_type in varchar2 ,
314: p_locality_code in varchar2,
315: p_print_term in varchar2) is

Line 325: l_report_type pay_payroll_actions.report_type%type;

321: num number;
322: l_effective_end_date DATE;
323:
324: l_effective_date DATE; /* 4152323 variables definitions start */
325: l_report_type pay_payroll_actions.report_type%type;
326: l_report_category pay_payroll_actions.report_category%type;
327: l_report_qualifier pay_payroll_actions.report_qualifier%type;
328: l_report_format pay_report_format_mappings_f.report_format%type;
329: l_range_person_on BOOLEAN;

Line 326: l_report_category pay_payroll_actions.report_category%type;

322: l_effective_end_date DATE;
323:
324: l_effective_date DATE; /* 4152323 variables definitions start */
325: l_report_type pay_payroll_actions.report_type%type;
326: l_report_category pay_payroll_actions.report_category%type;
327: l_report_qualifier pay_payroll_actions.report_qualifier%type;
328: l_report_format pay_report_format_mappings_f.report_format%type;
329: l_range_person_on BOOLEAN;
330:

Line 327: l_report_qualifier pay_payroll_actions.report_qualifier%type;

323:
324: l_effective_date DATE; /* 4152323 variables definitions start */
325: l_report_type pay_payroll_actions.report_type%type;
326: l_report_category pay_payroll_actions.report_category%type;
327: l_report_qualifier pay_payroll_actions.report_qualifier%type;
328: l_report_format pay_report_format_mappings_f.report_format%type;
329: l_range_person_on BOOLEAN;
330:
331: l_procedure_name VARCHAR2(100);

Line 403: from pay_payroll_actions

399: into l_effective_date,
400: l_report_type,
401: l_report_qualifier,
402: l_report_category
403: from pay_payroll_actions
404: where payroll_action_id = pactid;
405:
406: Begin
407: select report_format

Line 1351: p_eoy_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

1347: p_ssn in varchar2,
1348: p_state_code in pay_us_states.state_code%type,
1349: p_asg_set_id in number,
1350: p_session_date in date,
1351: p_eoy_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1352: p_eoy_start_date in date) is
1353:
1354: lockingactid number;
1355: lockedactid number;

Line 1362: l_report_type pay_payroll_actions.report_type%type;

1358: num number;
1359: l_effective_end_date DATE;
1360:
1361: l_effective_date DATE; /* 4152323 variables definitions start */
1362: l_report_type pay_payroll_actions.report_type%type;
1363: l_report_category pay_payroll_actions.report_category%type;
1364: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1365: l_report_format pay_report_format_mappings_f.report_format%type;
1366: l_range_person_on BOOLEAN;

Line 1363: l_report_category pay_payroll_actions.report_category%type;

1359: l_effective_end_date DATE;
1360:
1361: l_effective_date DATE; /* 4152323 variables definitions start */
1362: l_report_type pay_payroll_actions.report_type%type;
1363: l_report_category pay_payroll_actions.report_category%type;
1364: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1365: l_report_format pay_report_format_mappings_f.report_format%type;
1366: l_range_person_on BOOLEAN;
1367: /* 4152323 variables definitions end */

Line 1364: l_report_qualifier pay_payroll_actions.report_qualifier%type;

1360:
1361: l_effective_date DATE; /* 4152323 variables definitions start */
1362: l_report_type pay_payroll_actions.report_type%type;
1363: l_report_category pay_payroll_actions.report_category%type;
1364: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1365: l_report_format pay_report_format_mappings_f.report_format%type;
1366: l_range_person_on BOOLEAN;
1367: /* 4152323 variables definitions end */
1368:

Line 1450: from pay_payroll_actions

1446: into l_effective_date,
1447: l_report_type,
1448: l_report_qualifier,
1449: l_report_category
1450: from pay_payroll_actions
1451: where payroll_action_id = pactid;
1452:
1453: Begin
1454: select report_format

Line 2091: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

2087: l_per_id per_assignments_f.person_id%type;
2088: l_ssn per_people_f.national_identifier%type;
2089: l_state_code pay_us_states.state_code%type;
2090: l_asg_set_id number;
2091: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
2092: l_eoy_start_date date;
2093: -- BUG2538173
2094: l_locality_code varchar2(20);
2095: l_print_term varchar2(2);

Line 2098: l_report_type pay_payroll_actions.report_type%TYPE;

2094: l_locality_code varchar2(20);
2095: l_print_term varchar2(2);
2096:
2097:
2098: l_report_type pay_payroll_actions.report_type%TYPE;
2099:
2100: begin
2101: -- hr_utility.trace_on(null,'ORACLE');
2102: hr_utility.set_location('procpyr',1);

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

2130: l_eoy_start_date,
2131: l_report_type
2132: ,l_locality_code -- BUG2538173
2133: ,l_print_term
2134: from pay_payroll_actions ppa, /* EOY payroll action id */
2135: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
2136: where ppa1.payroll_action_id = pactid
2137: and ppa.effective_date = ppa1.effective_date
2138: and ppa.report_type = 'YREND'

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

2131: l_report_type
2132: ,l_locality_code -- BUG2538173
2133: ,l_print_term
2134: from pay_payroll_actions ppa, /* EOY payroll action id */
2135: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
2136: where ppa1.payroll_action_id = pactid
2137: and ppa.effective_date = ppa1.effective_date
2138: and ppa.report_type = 'YREND'
2139: and hr_us_w2_mt.get_parameter

Line 2222: l_bg_id pay_payroll_actions.business_group_id%type ;

2218: l_sort2 varchar2(60);
2219: l_sort3 varchar2(60);
2220: l_year_start date;
2221: l_year_end date;
2222: l_bg_id pay_payroll_actions.business_group_id%type ;
2223:
2224: begin
2225:
2226: begin

Line 2253: from pay_payroll_actions ppa

2249: l_sort3,
2250: l_dt, --session_date
2251: l_year_end,
2252: l_bg_id
2253: from pay_payroll_actions ppa
2254: where ppa.payroll_action_id = payactid;
2255:
2256: exception when no_data_found then
2257: hr_utility.trace('Error in Sort Procedure - getting legislative param');

Line 2342: token_val pay_payroll_actions.legislative_parameters%type;

2338: parameter_list varchar2) return varchar2
2339: is
2340: start_ptr number;
2341: end_ptr number;
2342: token_val pay_payroll_actions.legislative_parameters%type;
2343: par_value pay_payroll_actions.legislative_parameters%type;
2344: begin
2345: --
2346: token_val := name||'=';

Line 2343: par_value pay_payroll_actions.legislative_parameters%type;

2339: is
2340: start_ptr number;
2341: end_ptr number;
2342: token_val pay_payroll_actions.legislative_parameters%type;
2343: par_value pay_payroll_actions.legislative_parameters%type;
2344: begin
2345: --
2346: token_val := name||'=';
2347: --