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

173:
174: ----------------------------------- range_cursor -------------------------------
175: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
176:
177: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
178:
179: l_business_group_id pay_payroll_actions.business_group_id%type;
180:
181: l_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;

Line 179: l_business_group_id pay_payroll_actions.business_group_id%type;

175: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
176:
177: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
178:
179: l_business_group_id pay_payroll_actions.business_group_id%type;
180:
181: l_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;
182: l_error_mesg varchar2(100);
183: l_year number ;

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

195: into l_eoy_payroll_action_id
196: ,l_business_group_id
197: ,l_year
198: ,l_report_type
199: from pay_payroll_actions ppa, /* EOY payroll action id */
200: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
201: where ppa1.payroll_action_id = pactid
202: and ppa.effective_date = ppa1.effective_date
203: and ppa.report_type = 'YREND'

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

196: ,l_business_group_id
197: ,l_year
198: ,l_report_type
199: from pay_payroll_actions ppa, /* EOY payroll action id */
200: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
201: where ppa1.payroll_action_id = pactid
202: and ppa.effective_date = ppa1.effective_date
203: and ppa.report_type = 'YREND'
204: and hr_us_w2_mt.get_parameter

Line 320: p_eoy_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

316: p_ssn in varchar2,
317: p_state_code in pay_us_states.state_code%type,
318: p_asg_set_id in number,
319: p_session_date in date,
320: p_eoy_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
321: p_eoy_start_date in date,
322: p_report_type in varchar2 ,
323: p_locality_code in varchar2,
324: p_print_term in varchar2) is

Line 334: l_report_type pay_payroll_actions.report_type%type;

330: num number;
331: l_effective_end_date DATE;
332:
333: l_effective_date DATE; /* 4152323 variables definitions start */
334: l_report_type pay_payroll_actions.report_type%type;
335: l_report_category pay_payroll_actions.report_category%type;
336: l_report_qualifier pay_payroll_actions.report_qualifier%type;
337: l_report_format pay_report_format_mappings_f.report_format%type;
338: l_range_person_on BOOLEAN;

Line 335: l_report_category pay_payroll_actions.report_category%type;

331: l_effective_end_date DATE;
332:
333: l_effective_date DATE; /* 4152323 variables definitions start */
334: l_report_type pay_payroll_actions.report_type%type;
335: l_report_category pay_payroll_actions.report_category%type;
336: l_report_qualifier pay_payroll_actions.report_qualifier%type;
337: l_report_format pay_report_format_mappings_f.report_format%type;
338: l_range_person_on BOOLEAN;
339:

Line 336: l_report_qualifier pay_payroll_actions.report_qualifier%type;

332:
333: l_effective_date DATE; /* 4152323 variables definitions start */
334: l_report_type pay_payroll_actions.report_type%type;
335: l_report_category pay_payroll_actions.report_category%type;
336: l_report_qualifier pay_payroll_actions.report_qualifier%type;
337: l_report_format pay_report_format_mappings_f.report_format%type;
338: l_range_person_on BOOLEAN;
339:
340: l_procedure_name VARCHAR2(100);

Line 412: from pay_payroll_actions

408: into l_effective_date,
409: l_report_type,
410: l_report_qualifier,
411: l_report_category
412: from pay_payroll_actions
413: where payroll_action_id = pactid;
414:
415: Begin
416: select report_format

Line 1344: p_eoy_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

1340: p_ssn in varchar2,
1341: p_state_code in pay_us_states.state_code%type,
1342: p_asg_set_id in number,
1343: p_session_date in date,
1344: p_eoy_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1345: p_eoy_start_date in date,
1346: p_print_term in varchar2) is --6712851
1347:
1348: lockingactid number;

Line 1356: l_report_type pay_payroll_actions.report_type%type;

1352: num number;
1353: l_effective_end_date DATE;
1354:
1355: l_effective_date DATE; /* 4152323 variables definitions start */
1356: l_report_type pay_payroll_actions.report_type%type;
1357: l_report_category pay_payroll_actions.report_category%type;
1358: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1359: l_report_format pay_report_format_mappings_f.report_format%type;
1360: l_range_person_on BOOLEAN;

Line 1357: l_report_category pay_payroll_actions.report_category%type;

1353: l_effective_end_date DATE;
1354:
1355: l_effective_date DATE; /* 4152323 variables definitions start */
1356: l_report_type pay_payroll_actions.report_type%type;
1357: l_report_category pay_payroll_actions.report_category%type;
1358: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1359: l_report_format pay_report_format_mappings_f.report_format%type;
1360: l_range_person_on BOOLEAN;
1361: /* 4152323 variables definitions end */

Line 1358: l_report_qualifier pay_payroll_actions.report_qualifier%type;

1354:
1355: l_effective_date DATE; /* 4152323 variables definitions start */
1356: l_report_type pay_payroll_actions.report_type%type;
1357: l_report_category pay_payroll_actions.report_category%type;
1358: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1359: l_report_format pay_report_format_mappings_f.report_format%type;
1360: l_range_person_on BOOLEAN;
1361: /* 4152323 variables definitions end */
1362:

Line 1447: from pay_payroll_actions

1443: into l_effective_date,
1444: l_report_type,
1445: l_report_qualifier,
1446: l_report_category
1447: from pay_payroll_actions
1448: where payroll_action_id = pactid;
1449:
1450: Begin
1451: select report_format

Line 2192: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

2188: l_per_id per_assignments_f.person_id%type;
2189: l_ssn per_people_f.national_identifier%type;
2190: l_state_code pay_us_states.state_code%type;
2191: l_asg_set_id number;
2192: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
2193: l_eoy_start_date date;
2194: -- BUG2538173
2195: l_locality_code varchar2(20);
2196: l_print_term varchar2(2);

Line 2199: l_report_type pay_payroll_actions.report_type%TYPE;

2195: l_locality_code varchar2(20);
2196: l_print_term varchar2(2);
2197:
2198:
2199: l_report_type pay_payroll_actions.report_type%TYPE;
2200:
2201: begin
2202: -- hr_utility.trace_on(null,'ORACLE');
2203: hr_utility.set_location('procpyr',1);

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

2231: l_eoy_start_date,
2232: l_report_type
2233: ,l_locality_code -- BUG2538173
2234: ,l_print_term
2235: from pay_payroll_actions ppa, /* EOY payroll action id */
2236: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
2237: where ppa1.payroll_action_id = pactid
2238: and ppa.effective_date = ppa1.effective_date
2239: and ppa.report_type = 'YREND'

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

2232: l_report_type
2233: ,l_locality_code -- BUG2538173
2234: ,l_print_term
2235: from pay_payroll_actions ppa, /* EOY payroll action id */
2236: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
2237: where ppa1.payroll_action_id = pactid
2238: and ppa.effective_date = ppa1.effective_date
2239: and ppa.report_type = 'YREND'
2240: and hr_us_w2_mt.get_parameter

Line 2323: l_bg_id pay_payroll_actions.business_group_id%type ;

2319: l_sort2 varchar2(60);
2320: l_sort3 varchar2(60);
2321: l_year_start date;
2322: l_year_end date;
2323: l_bg_id pay_payroll_actions.business_group_id%type ;
2324:
2325: begin
2326:
2327: begin

Line 2354: from pay_payroll_actions ppa

2350: l_sort3,
2351: l_dt, --session_date
2352: l_year_end,
2353: l_bg_id
2354: from pay_payroll_actions ppa
2355: where ppa.payroll_action_id = payactid;
2356:
2357: exception when no_data_found then
2358: hr_utility.trace('Error in Sort Procedure - getting legislative param');

Line 2439: token_val pay_payroll_actions.legislative_parameters%type;

2435: parameter_list varchar2) return varchar2
2436: is
2437: start_ptr number;
2438: end_ptr number;
2439: token_val pay_payroll_actions.legislative_parameters%type;
2440: par_value pay_payroll_actions.legislative_parameters%type;
2441: begin
2442: --
2443: token_val := name||'=';

Line 2440: par_value pay_payroll_actions.legislative_parameters%type;

2436: is
2437: start_ptr number;
2438: end_ptr number;
2439: token_val pay_payroll_actions.legislative_parameters%type;
2440: par_value pay_payroll_actions.legislative_parameters%type;
2441: begin
2442: --
2443: token_val := name||'=';
2444: --