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 152: pay_payroll_actions in

148: balance call
149: 02-DEC-2002 asasthan 115.64 nocopy changes for gscc comp
150: 08-NOV-2002 asasthan 115.63 2589239 Suppressed effective_date index in
151: archive_data procedure for
152: pay_payroll_actions in
153: c_get_latest_asg cursor
154: 31-OCT-2002 asasthan 115.62 2589239 Suppressed effective_date index of
155: pay_payroll_actions in
156: c_get_latest_asg cursor

Line 155: pay_payroll_actions in

151: archive_data procedure for
152: pay_payroll_actions in
153: c_get_latest_asg cursor
154: 31-OCT-2002 asasthan 115.62 2589239 Suppressed effective_date index of
155: pay_payroll_actions in
156: c_get_latest_asg cursor
157: 23-SEP-2002 asasthan 115.61 2590094 Archiving of BOX 12 cursor change
158: 18-SEP-2002 fusman 115.60 Updated re-archiving changes.
159: 17-SEP-2002 asasthan 115.59 Added archiving of W2 Transmitter

Line 273: pay_payroll_actions.

269: balances.
270: 20-JAN-2000 ahanda 40.42 Changed the c_eoy_gre cursor
271: to go of the per_assignments_f
272: as a driving table instead of
273: pay_payroll_actions.
274: 12-dec-1999 ahanda 40.41 Added check in c_get_county and
275: c_get_state cursor to bypass the
276: picking up of user defined city tax
277: records.

Line 291: add the context of pay_payroll_actions

287: 25-oct-1999 djoshi 40.37 added the A_SS_EE_WAGE_BASE and
288: A_SS_EE_WAGE rate to archive the data
289: related to bug 983094 and 101435
290: 01-sep-1999 achauhan 40.33 While archiving the employer data
291: add the context of pay_payroll_actions
292: to ff_archive_item_contexts.
293: 11-aug-1999 achauhan 40.32 Added the call to
294: eoy_archive_gre_data in the
295: eoy_range_cursor procedure. This is

Line 430: from pay_payroll_actions ppa

426: effective_date,
427: start_date,
428: business_group_id,
429: creation_date
430: from pay_payroll_actions ppa
431: where ppa.payroll_action_id = cp_payroll_action_id;
432:
433: ld_end_date DATE;
434: ld_start_date DATE;

Line 514: from pay_payroll_actions ppa

510: IS
511:
512: cursor c_get_report_type is
513: select report_type
514: from pay_payroll_actions ppa
515: where ppa.payroll_action_id = p_payroll_action_id;
516:
517:
518: BEGIN

Line 1168: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

1164: FROM per_all_assignments_f ASG,
1165: pay_all_payrolls_f PPY
1166: WHERE exists
1167: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1168: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1169: 'x'
1170: from pay_payroll_actions ppa,
1171: pay_assignment_actions paa
1172: where ppa.effective_date between cp_period_start

Line 1170: from pay_payroll_actions ppa,

1166: WHERE exists
1167: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1168: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1169: 'x'
1170: from pay_payroll_actions ppa,
1171: pay_assignment_actions paa
1172: where ppa.effective_date between cp_period_start
1173: and cp_period_end
1174: and ppa.action_type in ('R','Q','V','B','I')

Line 1201: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

1197: per_all_assignments_f asg,
1198: pay_all_payrolls_f ppy
1199: where exists
1200: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1201: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1202: 'x'
1203: from pay_payroll_actions ppa,
1204: pay_assignment_actions paa
1205: where ppa.effective_date between cp_period_start

Line 1203: from pay_payroll_actions ppa,

1199: where exists
1200: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1201: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1202: 'x'
1203: from pay_payroll_actions ppa,
1204: pay_assignment_actions paa
1205: where ppa.effective_date between cp_period_start
1206: and cp_period_end
1207: and ppa.action_type in ('R','Q','V','B','I')

Line 1255: pay_payroll_actions ppa,

1251: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
1252: ||lpad(paa.assignment_action_id,15,'0')),16))
1253: from pay_assignment_actions paa,
1254: per_all_assignments_f paf,
1255: pay_payroll_actions ppa,
1256: pay_action_classifications pac
1257: where paf.person_id = cp_person_id
1258: and paa.assignment_id = paf.assignment_id
1259: and paa.tax_unit_id = cp_tax_unit_id

Line 1292: from pay_payroll_actions

1288: + length('TRANSFER_GRE=')))
1289: into l_effective_date,
1290: l_bus_group_id,
1291: l_eoy_tax_unit_id
1292: from pay_payroll_actions
1293: where payroll_action_id = pactid;
1294:
1295: l_year_start := trunc(l_effective_date, 'Y');
1296: l_year_end := add_months(trunc(l_effective_date, 'Y'),12) -1;

Line 1971: pay_payroll_actions ppa

1967: select ss_ee_wage_limit,
1968: ss_ee_rate
1969: into l_value1,l_value2
1970: from pay_us_federal_tax_info_f puftif,
1971: pay_payroll_actions ppa
1972: where ppa.payroll_action_id = p_payroll_action_id
1973: and ppa.effective_date between puftif.effective_start_date and effective_end_date
1974: and puftif.fed_information_category = '401K LIMITS';
1975: exception

Line 2724: from pay_payroll_actions

2720: instr(legislative_parameters,'TRANSFER_GRE=')+ length('TRANSFER_GRE='))),
2721: business_group_id
2722: into l_tax_unit_id,
2723: ln_business_group_id
2724: from pay_payroll_actions
2725: where payroll_action_id = p_payroll_action_id;
2726:
2727: else
2728:

Line 3162: pay_payroll_actions ppa,

3158: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
3159: ||lpad(paa.assignment_action_id,15,'0')),16))
3160: from pay_assignment_actions paa,
3161: per_all_assignments_f paf,
3162: pay_payroll_actions ppa,
3163: pay_action_classifications pac
3164: where paf.person_id = p_person_id
3165: and paa.assignment_id = paf.assignment_id
3166: and paa.tax_unit_id = l_taxunitid

Line 3238: , pay_payroll_actions BACT

3234: ,cp_asg_id IN NUMBER
3235: ,cp_ele_info1 IN VARCHAR2) IS
3236: SELECT TARGET.result_value
3237: FROM pay_assignment_actions BAL_ASSACT
3238: , pay_payroll_actions BACT
3239: , per_all_assignments_f ASS
3240: , pay_assignment_actions ASSACT
3241: , pay_payroll_actions PACT
3242: , pay_run_results RR

Line 3241: , pay_payroll_actions PACT

3237: FROM pay_assignment_actions BAL_ASSACT
3238: , pay_payroll_actions BACT
3239: , per_all_assignments_f ASS
3240: , pay_assignment_actions ASSACT
3241: , pay_payroll_actions PACT
3242: , pay_run_results RR
3243: , pay_run_result_values TARGET
3244: , pay_input_values_f PIV
3245: , pay_element_entries_f peef

Line 4474: l_eoy_bg_id pay_payroll_actions.business_group_id%TYPE;

4470: l_eoy_tax_unit_id number;
4471: l_archive boolean:= FALSE;
4472: l_step number;
4473:
4474: l_eoy_bg_id pay_payroll_actions.business_group_id%TYPE;
4475: l_start_date pay_payroll_actions.start_date%TYPE;
4476:
4477: l_processed varchar2(20);
4478: l_mesg varchar2(100);

Line 4475: l_start_date pay_payroll_actions.start_date%TYPE;

4471: l_archive boolean:= FALSE;
4472: l_step number;
4473:
4474: l_eoy_bg_id pay_payroll_actions.business_group_id%TYPE;
4475: l_start_date pay_payroll_actions.start_date%TYPE;
4476:
4477: l_processed varchar2(20);
4478: l_mesg varchar2(100);
4479:

Line 4490: pay_payroll_actions PPA

4486:
4487: eoy_gre_range := 'SELECT distinct ASG.person_id
4488: FROM per_all_assignments_f ASG,
4489: pay_us_asg_reporting puar,
4490: pay_payroll_actions PPA
4491: WHERE PPA.payroll_action_id = :payroll_action_id
4492: AND puar.tax_unit_id = substr(legislative_parameters,
4493: instr(legislative_parameters,''TRANSFER_GRE='')+ length(''TRANSFER_GRE=''))
4494: AND asg.assignment_id = puar.assignment_id

Line 4505: from pay_payroll_actions

4501:
4502: select to_number(substr(legislative_parameters,INSTR(legislative_parameters,
4503: 'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='),15)), business_group_id, start_date
4504: into l_eoy_tax_unit_id, l_eoy_bg_id, l_start_date
4505: from pay_payroll_actions
4506: where payroll_action_id = pactid;
4507:
4508: hr_utility.trace('TUI is : ' || to_char(l_eoy_tax_unit_id));
4509: hr_utility.trace('BG is : ' || to_char(l_eoy_bg_id));

Line 4526: from pay_payroll_actions ppa1

4522: and hou.business_group_id = l_eoy_bg_id
4523: and hou.organization_id = l_eoy_tax_unit_id;
4524:
4525: select 'X' into l_processed
4526: from pay_payroll_actions ppa1
4527: where ppa1.report_type = 'YREND'
4528: AND ppa1.business_group_id + 0 = l_eoy_bg_id
4529: AND ppa1.start_date = l_start_date
4530: AND ppa1.payroll_action_id <> pactid