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 966: from pay_payroll_actions ppa,

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

Line 967: pay_payroll_actions ppa1,

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

Line 1003: from pay_payroll_actions

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

Line 1032: pay_payroll_actions ppa

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

Line 1060: from pay_payroll_actions

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

Line 1254: pay_payroll_actions ppa

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