DBA Data[Home] [Help]

APPS.PQP_GB_AD_EE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1845: per_assignment_status_types past

1841: paf.assignment_id
1842: , pev.effective_start_date --10157179
1843: FROM pay_paye_element_entries_v pev,
1844: per_all_assignments_f paf,
1845: per_assignment_status_types past
1846: WHERE pev.assignment_id = paf.assignment_id
1847: AND past.assignment_status_type_id = paf.assignment_status_type_id
1848: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN', 'TERM_ASSIGN')
1849: /* 10157179. These two conditions are executed first in certain instances which makes the program to run for more than 20 hours