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

Line 183: pay_payroll_actions in

179: balance call
180: 02-DEC-2002 asasthan 115.64 nocopy changes for gscc comp
181: 08-NOV-2002 asasthan 115.63 2589239 Suppressed effective_date index in
182: archive_data procedure for
183: pay_payroll_actions in
184: c_get_latest_asg cursor
185: 31-OCT-2002 asasthan 115.62 2589239 Suppressed effective_date index of
186: pay_payroll_actions in
187: c_get_latest_asg cursor

Line 186: pay_payroll_actions in

182: archive_data procedure for
183: pay_payroll_actions in
184: c_get_latest_asg cursor
185: 31-OCT-2002 asasthan 115.62 2589239 Suppressed effective_date index of
186: pay_payroll_actions in
187: c_get_latest_asg cursor
188: 23-SEP-2002 asasthan 115.61 2590094 Archiving of BOX 12 cursor change
189: 18-SEP-2002 fusman 115.60 Updated re-archiving changes.
190: 17-SEP-2002 asasthan 115.59 Added archiving of W2 Transmitter

Line 304: pay_payroll_actions.

300: balances.
301: 20-JAN-2000 ahanda 40.42 Changed the c_eoy_gre cursor
302: to go of the per_assignments_f
303: as a driving table instead of
304: pay_payroll_actions.
305: 12-dec-1999 ahanda 40.41 Added check in c_get_county and
306: c_get_state cursor to bypass the
307: picking up of user defined city tax
308: records.

Line 322: add the context of pay_payroll_actions

318: 25-oct-1999 djoshi 40.37 added the A_SS_EE_WAGE_BASE and
319: A_SS_EE_WAGE rate to archive the data
320: related to bug 983094 and 101435
321: 01-sep-1999 achauhan 40.33 While archiving the employer data
322: add the context of pay_payroll_actions
323: to ff_archive_item_contexts.
324: 11-aug-1999 achauhan 40.32 Added the call to
325: eoy_archive_gre_data in the
326: eoy_range_cursor procedure. This is

Line 462: from pay_payroll_actions ppa

458: effective_date,
459: start_date,
460: business_group_id,
461: creation_date
462: from pay_payroll_actions ppa
463: where ppa.payroll_action_id = cp_payroll_action_id;
464:
465: ld_end_date DATE;
466: ld_start_date DATE;

Line 546: from pay_payroll_actions ppa

542: IS
543:
544: cursor c_get_report_type is
545: select report_type
546: from pay_payroll_actions ppa
547: where ppa.payroll_action_id = p_payroll_action_id;
548:
549:
550: BEGIN

Line 1472: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

1468: FROM per_all_assignments_f ASG,
1469: pay_all_payrolls_f PPY
1470: WHERE exists
1471: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1472: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1473: 'x'
1474: from pay_payroll_actions ppa,
1475: pay_assignment_actions paa
1476: where ppa.effective_date between cp_period_start

Line 1474: from pay_payroll_actions ppa,

1470: WHERE exists
1471: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1472: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1473: 'x'
1474: from pay_payroll_actions ppa,
1475: pay_assignment_actions paa
1476: where ppa.effective_date between cp_period_start
1477: and cp_period_end
1478: and ppa.action_type in ('R','Q','V','B','I')

Line 1505: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

1501: per_all_assignments_f asg,
1502: pay_all_payrolls_f ppy
1503: where exists
1504: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1505: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1506: 'x'
1507: from pay_payroll_actions ppa,
1508: pay_assignment_actions paa
1509: where ppa.effective_date between cp_period_start

Line 1507: from pay_payroll_actions ppa,

1503: where exists
1504: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1505: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1506: 'x'
1507: from pay_payroll_actions ppa,
1508: pay_assignment_actions paa
1509: where ppa.effective_date between cp_period_start
1510: and cp_period_end
1511: and ppa.action_type in ('R','Q','V','B','I')

Line 1559: pay_payroll_actions ppa,

1555: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
1556: ||lpad(paa.assignment_action_id,15,'0')),16))
1557: from pay_assignment_actions paa,
1558: per_all_assignments_f paf,
1559: pay_payroll_actions ppa,
1560: pay_action_classifications pac
1561: where paf.person_id = cp_person_id
1562: and paa.assignment_id = paf.assignment_id
1563: and paa.tax_unit_id = cp_tax_unit_id

Line 1596: from pay_payroll_actions

1592: + length('TRANSFER_GRE=')))
1593: into l_effective_date,
1594: l_bus_group_id,
1595: l_eoy_tax_unit_id
1596: from pay_payroll_actions
1597: where payroll_action_id = pactid;
1598:
1599: l_year_start := trunc(l_effective_date, 'Y');
1600: l_year_end := add_months(trunc(l_effective_date, 'Y'),12) -1;

Line 2339: pay_payroll_actions ppa

2335: select ss_ee_wage_limit,
2336: ss_ee_rate
2337: into l_value1,l_value2
2338: from pay_us_federal_tax_info_f puftif,
2339: pay_payroll_actions ppa
2340: where ppa.payroll_action_id = p_payroll_action_id
2341: and ppa.effective_date between puftif.effective_start_date and effective_end_date
2342: and puftif.fed_information_category = '401K LIMITS';
2343: exception

Line 3234: from pay_payroll_actions

3230: instr(legislative_parameters,'TRANSFER_GRE=')+ length('TRANSFER_GRE='))),
3231: business_group_id
3232: into l_tax_unit_id,
3233: ln_business_group_id
3234: from pay_payroll_actions
3235: where payroll_action_id = p_payroll_action_id;
3236:
3237: else
3238:

Line 3749: pay_payroll_actions ppa,

3745: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
3746: ||lpad(paa.assignment_action_id,15,'0')),16))
3747: from pay_assignment_actions paa,
3748: per_all_assignments_f paf,
3749: pay_payroll_actions ppa,
3750: pay_action_classifications pac
3751: where paf.person_id = p_person_id
3752: and paa.assignment_id = paf.assignment_id
3753: and paa.tax_unit_id = l_taxunitid

Line 3838: , pay_payroll_actions BACT

3834: ,cp_asg_id IN NUMBER
3835: ,cp_ele_info1 IN VARCHAR2) IS
3836: SELECT TARGET.result_value
3837: FROM pay_assignment_actions BAL_ASSACT
3838: , pay_payroll_actions BACT
3839: , per_all_assignments_f ASS
3840: , pay_assignment_actions ASSACT
3841: , pay_payroll_actions PACT
3842: , pay_run_results RR

Line 3841: , pay_payroll_actions PACT

3837: FROM pay_assignment_actions BAL_ASSACT
3838: , pay_payroll_actions BACT
3839: , per_all_assignments_f ASS
3840: , pay_assignment_actions ASSACT
3841: , pay_payroll_actions PACT
3842: , pay_run_results RR
3843: , pay_run_result_values TARGET
3844: , pay_input_values_f PIV
3845: , pay_element_entries_f peef

Line 3903: from pay_payroll_actions ppa,

3899:
3900: cursor c_get_business_group_id(cp_assignment_action_id number)
3901: is
3902: select business_group_id
3903: from pay_payroll_actions ppa,
3904: pay_assignment_actions paa
3905: where ppa.payroll_action_id = paa.payroll_action_id
3906: and paa.assignment_action_id = cp_assignment_action_id;
3907:

Line 5306: l_eoy_bg_id pay_payroll_actions.business_group_id%TYPE;

5302: l_eoy_tax_unit_id number;
5303: l_archive boolean:= FALSE;
5304: l_step number;
5305:
5306: l_eoy_bg_id pay_payroll_actions.business_group_id%TYPE;
5307: l_start_date pay_payroll_actions.start_date%TYPE;
5308:
5309: l_processed varchar2(20);
5310: l_mesg varchar2(100);

Line 5307: l_start_date pay_payroll_actions.start_date%TYPE;

5303: l_archive boolean:= FALSE;
5304: l_step number;
5305:
5306: l_eoy_bg_id pay_payroll_actions.business_group_id%TYPE;
5307: l_start_date pay_payroll_actions.start_date%TYPE;
5308:
5309: l_processed varchar2(20);
5310: l_mesg varchar2(100);
5311:

Line 5322: pay_payroll_actions PPA

5318:
5319: eoy_gre_range := 'SELECT distinct ASG.person_id
5320: FROM per_all_assignments_f ASG,
5321: pay_us_asg_reporting puar,
5322: pay_payroll_actions PPA
5323: WHERE PPA.payroll_action_id = :payroll_action_id
5324: AND puar.tax_unit_id = substr(legislative_parameters,
5325: instr(legislative_parameters,''TRANSFER_GRE='')+ length(''TRANSFER_GRE=''))
5326: AND asg.assignment_id = puar.assignment_id

Line 5337: from pay_payroll_actions

5333:
5334: select to_number(substr(legislative_parameters,INSTR(legislative_parameters,
5335: 'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='),15)), business_group_id, start_date
5336: into l_eoy_tax_unit_id, l_eoy_bg_id, l_start_date
5337: from pay_payroll_actions
5338: where payroll_action_id = pactid;
5339:
5340: hr_utility.trace('TUI is : ' || to_char(l_eoy_tax_unit_id));
5341: hr_utility.trace('BG is : ' || to_char(l_eoy_bg_id));

Line 5358: from pay_payroll_actions ppa1

5354: and hou.business_group_id = l_eoy_bg_id
5355: and hou.organization_id = l_eoy_tax_unit_id;
5356:
5357: select 'X' into l_processed
5358: from pay_payroll_actions ppa1
5359: where ppa1.report_type = 'YREND'
5360: AND ppa1.business_group_id + 0 = l_eoy_bg_id
5361: AND ppa1.start_date = l_start_date
5362: AND ppa1.payroll_action_id <> pactid