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

Line 89: FROM pay_payroll_actions ppa

85: p_year_end,
86: p_business_group_id,
87: p_state_abbrev,
88: p_report_type
89: FROM pay_payroll_actions ppa
90: WHERE payroll_action_id = p_pactid;
91: IF p_state_abbrev <> 'FED' THEN
92: SELECT state_code
93: INTO p_state_code

Line 230: pay_payroll_actions ppa_act

226: AND paf.assignment_type = 'E'
227: AND EXISTS
228: (SELECT 'x'
229: FROM pay_assignment_actions paa_act,
230: pay_payroll_actions ppa_act
231: WHERE paa_act.assignment_id = paf.assignment_id
232: AND paa_act.tax_unit_id = cp_tax_unit_id
233: AND ppa_act.payroll_action_id = paa_act.payroll_action_id
234: AND ppa_act.action_type IN ('R', 'Q', 'B', 'I', 'V')

Line 258: FROM pay_payroll_actions ppa_act,

254: AND paf.effective_end_date >= p_year_start
255: AND paf.assignment_type = 'E'
256: AND EXISTS (
257: SELECT 'x'
258: FROM pay_payroll_actions ppa_act,
259: pay_assignment_actions paa_act
260: WHERE paa_act.assignment_id = paf.assignment_id
261: AND paa_act.tax_unit_id = cp_tax_unit_id
262: AND ppa_act.payroll_action_id = paa_act.payroll_action_id

Line 277: FROM pay_payroll_actions

273: -- This will also serve as a check to make sure that all GREs have been
274: -- archived
275: CURSOR c_gre_payroll_action (cp_gre NUMBER) IS
276: SELECT payroll_action_id
277: FROM pay_payroll_actions
278: WHERE report_type = 'YREND'
279: AND effective_date = p_year_end
280: AND start_date = p_year_start
281: AND business_group_id+0 = p_business_group_id

Line 358: pay_payroll_actions ppa

354: SELECT 'Y'
355: FROM
356: ff_archive_items fai,
357: pay_assignment_actions paa,
358: pay_payroll_actions ppa
359: WHERE ppa.PAYROLL_ACTION_ID = CP_PAYROLL_ACTION_ID
360: AND ppa.payroll_action_id = paa.payroll_action_id
361: AND paa.assignment_action_id = fai.context1
362: AND fai.user_entity_id = cp_user_entity_id

Line 414: FROM pay_payroll_actions

410: + LENGTH('TRANSFER_TRANS_LEGAL_CO_ID='),
411: (INSTR(legislative_parameters, 'TRANSFER_DATE=')
412: - INSTR(legislative_parameters, 'TRANSFER_TRANS_LEGAL_CO_ID=')
413: - LENGTH('TRANSFER_TRANS_LEGAL_CO_ID=')-1 ))
414: FROM pay_payroll_actions
415: WHERE report_type = 'W2'
416: AND effective_date = p_year_end
417: AND report_qualifier = p_state_abbrev
418: AND business_group_id = p_business_group_id

Line 808: pay_payroll_actions ppa,

804: p_sqlstr := '
805: SELECT DISTINCT paf.person_id
806: FROM per_assignments_f paf,
807: pay_assignment_actions paa,
808: pay_payroll_actions ppa,
809: pay_payroll_actions ppa1
810: WHERE ppa1.payroll_action_id = :payroll_action_id
811: AND ppa.report_type = ''YREND''
812: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 809: pay_payroll_actions ppa1

805: SELECT DISTINCT paf.person_id
806: FROM per_assignments_f paf,
807: pay_assignment_actions paa,
808: pay_payroll_actions ppa,
809: pay_payroll_actions ppa1
810: WHERE ppa1.payroll_action_id = :payroll_action_id
811: AND ppa.report_type = ''YREND''
812: AND ppa.business_group_id+0 = ppa1.business_group_id
813: AND ppa.effective_date = ppa1.effective_date

Line 839: pay_payroll_actions ppa,

835: FROM ff_archive_item_contexts faic,
836: ff_archive_items fai,
837: ff_database_items fdi,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa,
840: per_assignments_f paf,
841: pay_payroll_actions ppa1
842: WHERE
843: ppa1.payroll_action_id = :payroll_action_id

Line 841: pay_payroll_actions ppa1

837: ff_database_items fdi,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa,
840: per_assignments_f paf,
841: pay_payroll_actions ppa1
842: WHERE
843: ppa1.payroll_action_id = :payroll_action_id
844: AND ppa.business_group_id+0 = ppa1.business_group_id
845: AND ppa1.effective_date = ppa.effective_date

Line 926: pay_payroll_actions ppa,

922: FROM ff_archive_item_contexts faic,
923: ff_archive_items fai,
924: ff_database_items fdi,
925: pay_assignment_actions paa,
926: pay_payroll_actions ppa,
927: per_assignments_f paf,
928: pay_payroll_actions ppa1
929: WHERE
930: ppa1.payroll_action_id = p_pactid

Line 928: pay_payroll_actions ppa1

924: ff_database_items fdi,
925: pay_assignment_actions paa,
926: pay_payroll_actions ppa,
927: per_assignments_f paf,
928: pay_payroll_actions ppa1
929: WHERE
930: ppa1.payroll_action_id = p_pactid
931: and ppa.business_group_id+0 = ppa1.business_group_id
932: and ppa1.effective_date = ppa.effective_date

Line 974: FROM pay_payroll_actions ppa,

970: paf.assignment_id,
971: Paa.tax_unit_id, --TO_NUMBER(hsck.segment1),
972: paf.effective_end_date,
973: paa.assignment_action_id
974: FROM pay_payroll_actions ppa,
975: pay_assignment_actions paa,
976: --hr_soft_coding_keyflex hsck,
977: per_assignments_f paf,
978: pay_payroll_actions ppa1

Line 978: pay_payroll_actions ppa1

974: FROM pay_payroll_actions ppa,
975: pay_assignment_actions paa,
976: --hr_soft_coding_keyflex hsck,
977: per_assignments_f paf,
978: pay_payroll_actions ppa1
979: WHERE ppa1.payroll_action_id = p_pactid
980: AND ppa.report_type = 'YREND'
981: AND ppa.business_group_id+0 = ppa1.business_group_id
982: AND ppa.effective_date = ppa1.effective_date