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

Line 207: FROM pay_payroll_actions ppa

203: ppa.effective_date,
204: ppa.business_group_id,
205: ppa.report_qualifier,
206: ppa.report_type
207: FROM pay_payroll_actions ppa
208: WHERE payroll_action_id = p_payroll_action_id;
209:
210: -- Cursor to fetch the YREND ARCHIVER Payroll action id for TCC Gre
211: cursor c_yrend_ppa(p_tax_unit_id NUMBER, p_payroll_action_id NUMBER) is

Line 213: from pay_payroll_actions ppa, -- YREND

209:
210: -- Cursor to fetch the YREND ARCHIVER Payroll action id for TCC Gre
211: cursor c_yrend_ppa(p_tax_unit_id NUMBER, p_payroll_action_id NUMBER) is
212: select ppa.payroll_action_id
213: from pay_payroll_actions ppa, -- YREND
214: pay_payroll_actions ppa1 -- 1099R
215: where ppa1.payroll_action_id = p_payroll_action_id -- 1099R
216: and ppa.report_type = 'YREND'
217: and ppa.effective_date = ppa1.effective_date

Line 214: pay_payroll_actions ppa1 -- 1099R

210: -- Cursor to fetch the YREND ARCHIVER Payroll action id for TCC Gre
211: cursor c_yrend_ppa(p_tax_unit_id NUMBER, p_payroll_action_id NUMBER) is
212: select ppa.payroll_action_id
213: from pay_payroll_actions ppa, -- YREND
214: pay_payroll_actions ppa1 -- 1099R
215: where ppa1.payroll_action_id = p_payroll_action_id -- 1099R
216: and ppa.report_type = 'YREND'
217: and ppa.effective_date = ppa1.effective_date
218: and ppa.business_group_id + 0 = ppa1.business_group_id

Line 232: lv_leg_param pay_payroll_actions.legislative_parameters%type;

228: lv_state_code varchar2(10);
229: lv_tax_unit_id varchar2(30);
230: lv_trans_cont_code varchar2(30);
231: ln_yrend_ppa_id number;
232: lv_leg_param pay_payroll_actions.legislative_parameters%type;
233:
234: begin
235:
236: hr_utility.trace('Entering pay_us_1099r_mag_reporting.get_selection_information');

Line 281: from pay_payroll_actions ppa

277:
278:
279: select legislative_parameters
280: into lv_leg_param
281: from pay_payroll_actions ppa
282: where ppa.payroll_action_id = p_payroll_action_id;
283:
284: lv_tax_unit_id := get_parameter('TRANSFER_TRANS_LEGAL_CO_ID', lv_leg_param);
285:

Line 505: from pay_payroll_actions

501: cp_year_start date,
502: cp_year_end date,
503: cp_business_group_id number) is
504: select payroll_action_id
505: from pay_payroll_actions
506: where report_type = 'YREND'
507: and effective_date = cp_year_end
508: and start_date = cp_year_start
509: and business_group_id + 0 = cp_business_group_id

Line 839: pay_payroll_actions ppa1,

835: 'select distinct paf.person_id
836: from --hr_soft_coding_keyflex hsck,
837: per_all_assignments_f paf,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa1,
840: pay_payroll_actions ppa
841: where ppa1.payroll_action_id = :p_payroll_action_id
842: and ppa.report_type = ''YREND''
843: and ppa.business_group_id + 0 = ppa1.business_group_id

Line 840: pay_payroll_actions ppa

836: from --hr_soft_coding_keyflex hsck,
837: per_all_assignments_f paf,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa1,
840: pay_payroll_actions ppa
841: where ppa1.payroll_action_id = :p_payroll_action_id
842: and ppa.report_type = ''YREND''
843: and ppa.business_group_id + 0 = ppa1.business_group_id
844: and ppa.effective_date = ppa1.effective_date

Line 874: pay_payroll_actions ppa

870: from --hr_soft_coding_keyflex hsck,
871: hr_organization_units hou,
872: per_all_assignments_f paf,
873: pay_us_state_w2_v psv,
874: pay_payroll_actions ppa
875: where ppa.payroll_action_id = :p_payroll_action_id
876: and hou.business_group_id + 0 = ppa.business_group_id + 0
877: and psv.tax_unit_id = hou.organization_id
878: and psv.action_status = ''C''

Line 967: from pay_payroll_actions ppa,

963: paf.effective_end_date,
964: paf.assignment_id,
965: --pww.wages_tips_compensation
966: pww.gross_1099r
967: from pay_payroll_actions ppa,
968: pay_payroll_actions ppa1,
969: pay_us_wages_1099r_v pww,
970: per_all_assignments_f paf,
971: pay_assignment_actions paa

Line 968: pay_payroll_actions ppa1,

964: paf.assignment_id,
965: --pww.wages_tips_compensation
966: pww.gross_1099r
967: from pay_payroll_actions ppa,
968: pay_payroll_actions ppa1,
969: pay_us_wages_1099r_v pww,
970: per_all_assignments_f paf,
971: pay_assignment_actions paa
972: where ppa1.payroll_action_id = cp_payroll_action_id

Line 1004: from pay_payroll_actions

1000: and ffc.context_name = 'TAX_UNIT_ID'
1001: and ffai2.user_entity_id = ffai.user_entity_id
1002: and ffai2.value = ffai.value
1003: and ffai2.context1 in (select payroll_action_id
1004: from pay_payroll_actions
1005: where report_type = 'YREND'
1006: and effective_date = ppa.effective_date)
1007: and ffai2.archive_item_id = ffaic2.archive_item_id
1008: and ffaic2.context_id = ffc2.context_id

Line 1033: pay_payroll_actions ppa

1029: psv.w2_state_wages,
1030: psv.w2_state_income_tax
1031: from per_all_assignments_f paf,
1032: pay_us_state_w2_v psv,
1033: pay_payroll_actions ppa
1034: where ppa.payroll_action_id = cp_payroll_action_id
1035: and psv.year = to_number(to_char(ppa.effective_date, 'YYYY'))
1036: and psv.state_abbrev = ppa.report_qualifier
1037: and psv.assignment_id = paf.assignment_id

Line 1062: from pay_payroll_actions

1058: and ffc.context_name = 'TAX_UNIT_ID'
1059: and ffai2.user_entity_id = ffai.user_entity_id
1060: and ffai2.value = ffai.value
1061: and ffai2.context1 in (select payroll_action_id
1062: from pay_payroll_actions
1063: where report_type = 'YREND'
1064: and effective_date = ppa.effective_date)
1065: and ffai2.archive_item_id = ffaic2.archive_item_id
1066: and ffaic2.context_id = ffc2.context_id

Line 1256: pay_payroll_actions ppa

1252: --Create Interlock
1253: select assignment_action_id into ln_lockedactid
1254: from pay_assignment_actions paa,
1255: per_all_assignments_f paf,
1256: pay_payroll_actions ppa
1257: where paa.payroll_action_id = ppa.payroll_action_id
1258: and paa.assignment_id = paf.assignment_id
1259: and paa.tax_unit_id = ln_tax_unit_id
1260: and ppa.report_type = 'YREND'