DBA Data[Home] [Help]

APPS.PQP_GB_AD_EE dependencies on PER_PERIODS_OF_SERVICE

Line 719: FROM per_periods_of_service pds

715:
716: CURSOR c_term
717: IS
718: SELECT 'Y' terminated
719: FROM per_periods_of_service pds
720: ,per_assignments_f pas
721: WHERE NVL(pds.final_process_date,hr_api.g_eot) >= p_effective_date
722: AND pds.last_standard_process_date <= p_effective_date
723: AND pds.period_of_service_id = pas.period_of_service_id

Line 747: per_periods_of_service service_period

743: FROM pay_element_types_f_tl elementtl,
744: pay_element_types_f element,
745: pay_element_links_f link,
746: per_all_assignments_f asgt ,
747: per_periods_of_service service_period
748: WHERE
749: --element.element_type_id = elementtl.element_type_id
750: -- AND elementtl.language = USERENV('LANG')
751: --AND