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

Line 154: FROM pay_payroll_actions ppa

150: p_business_group_id,
151: p_state_abbrev,
152: p_report_type,
153: p_locality_code
154: FROM pay_payroll_actions ppa
155: WHERE payroll_action_id = p_pactid;
156: IF p_state_abbrev <> 'FED' THEN
157: SELECT state_code
158: INTO p_state_code

Line 291: FROM pay_payroll_actions

287: -- archived
288: CURSOR c_gre_payroll_action (cp_gre NUMBER)
289: IS
290: SELECT payroll_action_id
291: FROM pay_payroll_actions
292: WHERE report_type = 'YREND'
293: AND effective_date = p_year_end
294: AND start_date = p_year_start
295: AND business_group_id+0 = p_business_group_id

Line 387: FROM pay_payroll_actions

383: + LENGTH('TRANSFER_TRANS_LEGAL_CO_ID='),
384: (INSTR(legislative_parameters, 'TRANSFER_DATE=')
385: - INSTR(legislative_parameters, 'TRANSFER_TRANS_LEGAL_CO_ID=')
386: - LENGTH('TRANSFER_TRANS_LEGAL_CO_ID=')-1 ))
387: FROM pay_payroll_actions
388: WHERE report_type = 'W2'
389: AND effective_date = p_year_end
390: --CPE
391: --AND report_qualifier = p_state_abbrev

Line 873: pay_payroll_actions ppa,

869: p_sqlstr := '
870: SELECT DISTINCT paf.person_id
871: FROM per_all_assignments_f paf,
872: pay_assignment_actions paa,
873: pay_payroll_actions ppa,
874: pay_payroll_actions ppa1
875: WHERE ppa1.payroll_action_id = :payroll_action_id
876: AND ppa.report_type = ''YREND''
877: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 874: pay_payroll_actions ppa1

870: SELECT DISTINCT paf.person_id
871: FROM per_all_assignments_f paf,
872: pay_assignment_actions paa,
873: pay_payroll_actions ppa,
874: pay_payroll_actions ppa1
875: WHERE ppa1.payroll_action_id = :payroll_action_id
876: AND ppa.report_type = ''YREND''
877: AND ppa.business_group_id+0 = ppa1.business_group_id
878: AND ppa.effective_date = ppa1.effective_date

Line 904: pay_payroll_actions ppa,

900: FROM ff_archive_item_contexts faic,
901: ff_archive_items fai,
902: ff_database_items fdi,
903: pay_assignment_actions paa,
904: pay_payroll_actions ppa,
905: per_all_assignments_f paf,
906: pay_payroll_actions ppa1
907: WHERE
908: ppa1.payroll_action_id = :payroll_action_id

Line 906: pay_payroll_actions ppa1

902: ff_database_items fdi,
903: pay_assignment_actions paa,
904: pay_payroll_actions ppa,
905: per_all_assignments_f paf,
906: pay_payroll_actions ppa1
907: WHERE
908: ppa1.payroll_action_id = :payroll_action_id
909: AND ppa.business_group_id+0 = ppa1.business_group_id
910: AND ppa1.effective_date = ppa.effective_date

Line 993: pay_payroll_actions ppa, /* YREND PPA */

989: fai1.value
990:
991: FROM
992: pay_assignment_actions paa, /* YREND PAA */
993: pay_payroll_actions ppa, /* YREND PPA */
994: per_all_assignments_f paf,
995: pay_payroll_actions ppa1,
996: ff_contexts fc1 , --for city context
997: ff_archive_items fai1, -- city

Line 995: pay_payroll_actions ppa1,

991: FROM
992: pay_assignment_actions paa, /* YREND PAA */
993: pay_payroll_actions ppa, /* YREND PPA */
994: per_all_assignments_f paf,
995: pay_payroll_actions ppa1,
996: ff_contexts fc1 , --for city context
997: ff_archive_items fai1, -- city
998: ff_archive_item_contexts faic1, -- city_context
999: ff_database_items fdi1 --database_items for City_withheld

Line 1052: FROM pay_payroll_actions ppa,

1048: paf.assignment_id,
1049: Paa.tax_unit_id, --TO_NUMBER(hsck.segment1),
1050: paf.effective_end_date,
1051: paa.assignment_action_id
1052: FROM pay_payroll_actions ppa,
1053: pay_assignment_actions paa,
1054: per_all_assignments_f paf,
1055: pay_payroll_actions ppa1
1056: WHERE ppa1.payroll_action_id = p_pactid

Line 1055: pay_payroll_actions ppa1

1051: paa.assignment_action_id
1052: FROM pay_payroll_actions ppa,
1053: pay_assignment_actions paa,
1054: per_all_assignments_f paf,
1055: pay_payroll_actions ppa1
1056: WHERE ppa1.payroll_action_id = p_pactid
1057: AND ppa.report_type = 'YREND'
1058: AND ppa.business_group_id+0 = ppa1.business_group_id
1059: AND ppa.effective_date = ppa1.effective_date

Line 1429: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */

1425: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
1426: IS
1427: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
1428: FROM pay_assignment_actions paa
1429: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
1430: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
1431: ,hr_organization_units hou
1432: WHERE
1433: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */

Line 1430: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */

1426: IS
1427: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
1428: FROM pay_assignment_actions paa
1429: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
1430: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
1431: ,hr_organization_units hou
1432: WHERE
1433: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */
1434: and ppa.payroll_action_id = paa.payroll_action_id