DBA Data[Home] [Help]

APPS.PAY_ES_SS_CALCULATION dependencies on PER_TIME_PERIODS

Line 659: ,per_time_periods ptp

655: ,per_all_assignments_f paaf1
656: ,per_all_assignments_f paaf2
657: ,pay_payroll_actions ppa
658: ,pay_payroll_actions ppa1
659: ,per_time_periods ptp
660: ,per_time_period_types ptpt
661: WHERE paa1.assignment_action_id = c_assignment_action_id
662: AND ppa1.payroll_action_id = paa1.payroll_action_id
663: AND ppa1.business_group_id = paaf1.business_group_id

Line 692: ,per_time_periods ptp

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
693: WHERE paa1.assignment_action_id = c_assignment_action_id
694: AND paa1.assignment_id = paaf1.assignment_id
695: AND paaf1.person_id = paaf2.person_id
696: AND paaf2.assignment_id = paa2.assignment_id

Line 1613: ,per_time_periods ptp

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
1615: WHERE paa1.assignment_action_id = c_assignment_action_id
1616: AND ppa1.payroll_action_id = paa1.payroll_action_id
1617: AND ppa1.business_group_id = paaf1.business_group_id

Line 1645: ,per_time_periods ptp

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
1646: WHERE paa1.assignment_action_id = c_assignment_action_id
1647: AND paa1.assignment_id = paaf1.assignment_id
1648: AND paaf1.person_id = paaf2.person_id
1649: AND paaf2.assignment_id = paa2.assignment_id