APPS.PAY_US_MMREF_REPORTING1 dependencies on PAY_PAYROLL_ACTIONS

Line 110: FROM pay_payroll_actions ppa

106: p_year_end,
107: p_business_group_id,
108: p_state_abbrev,
109: p_report_type
110: FROM pay_payroll_actions ppa
111: WHERE payroll_action_id = p_pactid;
112: IF p_state_abbrev <> 'FED' THEN
113: SELECT state_code
114: INTO p_state_code

Line 248: FROM pay_payroll_actions

244: -- archived
245: CURSOR c_gre_payroll_action (cp_gre NUMBER)
246: IS
247: SELECT payroll_action_id
248: FROM pay_payroll_actions
249: WHERE report_type = 'YREND'
250: AND effective_date = p_year_end
251: AND start_date = p_year_start
252: AND business_group_id+0 = p_business_group_id

Line 344: FROM pay_payroll_actions

340: + LENGTH('TRANSFER_TRANS_LEGAL_CO_ID='),
341: (INSTR(legislative_parameters, 'TRANSFER_DATE=')
342: - INSTR(legislative_parameters, 'TRANSFER_TRANS_LEGAL_CO_ID=')
343: - LENGTH('TRANSFER_TRANS_LEGAL_CO_ID=')-1 ))
344: FROM pay_payroll_actions
345: WHERE report_type = 'W2'
346: AND effective_date = p_year_end
347: AND report_qualifier = p_state_abbrev
348: AND business_group_id = p_business_group_id

Line 825: pay_payroll_actions ppa,

821: p_sqlstr := '
822: SELECT DISTINCT paf.person_id
823: FROM per_all_assignments_f paf,
824: pay_assignment_actions paa,
825: pay_payroll_actions ppa,
826: pay_payroll_actions ppa1
827: WHERE ppa1.payroll_action_id = :payroll_action_id
828: AND ppa.report_type = ''YREND''
829: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 826: pay_payroll_actions ppa1

822: SELECT DISTINCT paf.person_id
823: FROM per_all_assignments_f paf,
824: pay_assignment_actions paa,
825: pay_payroll_actions ppa,
826: pay_payroll_actions ppa1
827: WHERE ppa1.payroll_action_id = :payroll_action_id
828: AND ppa.report_type = ''YREND''
829: AND ppa.business_group_id+0 = ppa1.business_group_id
830: AND ppa.effective_date = ppa1.effective_date

Line 856: pay_payroll_actions ppa,

852: FROM ff_archive_item_contexts faic,
853: ff_archive_items fai,
854: ff_database_items fdi,
855: pay_assignment_actions paa,
856: pay_payroll_actions ppa,
857: per_all_assignments_f paf,
858: pay_payroll_actions ppa1
859: WHERE
860: ppa1.payroll_action_id = :payroll_action_id

Line 858: pay_payroll_actions ppa1

854: ff_database_items fdi,
855: pay_assignment_actions paa,
856: pay_payroll_actions ppa,
857: per_all_assignments_f paf,
858: pay_payroll_actions ppa1
859: WHERE
860: ppa1.payroll_action_id = :payroll_action_id
861: AND ppa.business_group_id+0 = ppa1.business_group_id
862: AND ppa1.effective_date = ppa.effective_date

Line 944: pay_payroll_actions ppa,

940: FROM ff_archive_item_contexts faic,
941: ff_archive_items fai,
942: ff_database_items fdi,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa,
945: per_all_assignments_f paf,
946: pay_payroll_actions ppa1
947: WHERE
948: ppa1.payroll_action_id = p_pactid

Line 946: pay_payroll_actions ppa1

942: ff_database_items fdi,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa,
945: per_all_assignments_f paf,
946: pay_payroll_actions ppa1
947: WHERE
948: ppa1.payroll_action_id = p_pactid
949: and ppa.business_group_id+0 = ppa1.business_group_id
950: and ppa1.effective_date = ppa.effective_date

Line 1008: pay_payroll_actions ppa,

1004: FROM ff_archive_item_contexts faic,
1005: ff_archive_items fai,
1006: ff_database_items fdi,
1007: pay_assignment_actions paa,
1008: pay_payroll_actions ppa,
1009: per_all_assignments_f paf,
1010: pay_payroll_actions ppa1
1011: WHERE
1012: ppa1.payroll_action_id = p_pactid

Line 1010: pay_payroll_actions ppa1

1006: ff_database_items fdi,
1007: pay_assignment_actions paa,
1008: pay_payroll_actions ppa,
1009: per_all_assignments_f paf,
1010: pay_payroll_actions ppa1
1011: WHERE
1012: ppa1.payroll_action_id = p_pactid
1013: and ppa.business_group_id+0 = ppa1.business_group_id
1014: and ppa1.effective_date = ppa.effective_date

Line 1056: FROM pay_payroll_actions ppa,

1052: paf.assignment_id,
1053: Paa.tax_unit_id, --TO_NUMBER(hsck.segment1),
1054: paf.effective_end_date,
1055: paa.assignment_action_id
1056: FROM pay_payroll_actions ppa,
1057: pay_assignment_actions paa,
1058: per_all_assignments_f paf,
1059: pay_payroll_actions ppa1
1060: WHERE ppa1.payroll_action_id = p_pactid

Line 1059: pay_payroll_actions ppa1

1055: paa.assignment_action_id
1056: FROM pay_payroll_actions ppa,
1057: pay_assignment_actions paa,
1058: per_all_assignments_f paf,
1059: pay_payroll_actions ppa1
1060: WHERE ppa1.payroll_action_id = p_pactid
1061: AND ppa.report_type = 'YREND'
1062: AND ppa.business_group_id+0 = ppa1.business_group_id
1063: AND ppa.effective_date = ppa1.effective_date

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

1518: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
1519: IS
1520: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
1521: FROM pay_assignment_actions paa
1522: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
1523: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
1524: ,hr_organization_units hou
1525: WHERE
1526: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */

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

1519: IS
1520: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
1521: FROM pay_assignment_actions paa
1522: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
1523: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
1524: ,hr_organization_units hou
1525: WHERE
1526: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */
1527: and ppa.payroll_action_id = paa.payroll_action_id

Line 1703: FROM pay_payroll_actions ppa,

1699: SELECT 'RG'
1700: FROM DUAL
1701: WHERE EXISTS
1702: (SELECT NULL
1703: FROM pay_payroll_actions ppa,
1704: ff_archive_items fai
1705: WHERE ppa.report_type = 'YREND'
1706: AND ppa.report_qualifier = 'FED'
1707: AND ppa.report_category = 'RT'