DBA Data[Home] [Help]

APPS.PAY_ES_SS_CALCULATION dependencies on PAY_ASSIGNMENT_ACTIONS

Line 653: FROM pay_assignment_actions paa1

649: SELECT ptp.start_date start_date
650: ,ptp.end_date end_date
651: ,ppa.action_type
652: ,MAX(paa2.assignment_action_id) assignment_action_id
653: FROM pay_assignment_actions paa1
654: ,pay_assignment_actions paa2
655: ,per_all_assignments_f paaf1
656: ,per_all_assignments_f paaf2
657: ,pay_payroll_actions ppa

Line 654: ,pay_assignment_actions paa2

650: ,ptp.end_date end_date
651: ,ppa.action_type
652: ,MAX(paa2.assignment_action_id) assignment_action_id
653: FROM pay_assignment_actions paa1
654: ,pay_assignment_actions paa2
655: ,per_all_assignments_f paaf1
656: ,per_all_assignments_f paaf2
657: ,pay_payroll_actions ppa
658: ,pay_payroll_actions ppa1

Line 687: FROM pay_assignment_actions paa1

683: /* SELECT ptp.start_date start_date
684: ,ptp.end_date end_date
685: ,ppa.action_type
686: ,MAX(paa2.assignment_action_id) assignment_action_id
687: FROM pay_assignment_actions paa1
688: ,pay_assignment_actions paa2
689: ,per_all_assignments_f paaf1
690: ,per_all_assignments_f paaf2
691: ,pay_payroll_actions ppa

Line 688: ,pay_assignment_actions paa2

684: ,ptp.end_date end_date
685: ,ppa.action_type
686: ,MAX(paa2.assignment_action_id) assignment_action_id
687: FROM pay_assignment_actions paa1
688: ,pay_assignment_actions paa2
689: ,per_all_assignments_f paaf1
690: ,per_all_assignments_f paaf2
691: ,pay_payroll_actions ppa
692: ,per_time_periods ptp

Line 1607: FROM pay_assignment_actions paa1

1603: SELECT ptp.start_date start_date
1604: ,ptp.end_date end_date
1605: ,ppa.action_type
1606: ,max(paa2.assignment_action_id) assignment_action_id
1607: FROM pay_assignment_actions paa1
1608: ,per_all_assignments_f paaf1
1609: ,per_all_assignments_f paaf2
1610: ,pay_assignment_actions paa2
1611: ,pay_payroll_actions ppa

Line 1610: ,pay_assignment_actions paa2

1606: ,max(paa2.assignment_action_id) assignment_action_id
1607: FROM pay_assignment_actions paa1
1608: ,per_all_assignments_f paaf1
1609: ,per_all_assignments_f paaf2
1610: ,pay_assignment_actions paa2
1611: ,pay_payroll_actions ppa
1612: ,pay_payroll_actions ppa1
1613: ,per_time_periods ptp
1614: ,per_time_period_types ptpt

Line 1640: FROM pay_assignment_actions paa1

1636: /* SELECT ptp.start_date start_date
1637: ,ptp.end_date end_date
1638: ,ppa.action_type
1639: ,MAX(paa2.assignment_action_id) assignment_action_id
1640: FROM pay_assignment_actions paa1
1641: ,pay_assignment_actions paa2
1642: ,per_all_assignments_f paaf1
1643: ,per_all_assignments_f paaf2
1644: ,pay_payroll_actions ppa

Line 1641: ,pay_assignment_actions paa2

1637: ,ptp.end_date end_date
1638: ,ppa.action_type
1639: ,MAX(paa2.assignment_action_id) assignment_action_id
1640: FROM pay_assignment_actions paa1
1641: ,pay_assignment_actions paa2
1642: ,per_all_assignments_f paaf1
1643: ,per_all_assignments_f paaf2
1644: ,pay_payroll_actions ppa
1645: ,per_time_periods ptp