DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 521: per_periods_of_service service_period

517: pay_element_types_f element,
518: pay_element_links_f link,
519: per_all_assignments_f asgt ,
520: pay_element_type_extra_info pete,
521: per_periods_of_service service_period
522: WHERE element.element_type_id = elementtl.element_type_id
523: AND elementtl.language = USERENV('LANG')
524: AND asgt.business_group_id = link.business_group_id
525: AND asgt.business_group_id = element.business_group_id

Line 643: per_periods_of_service service_period

639: pay_element_types_f element,
640: pay_element_links_f link,
641: per_all_assignments_f asgt ,
642: pay_element_type_extra_info pete,
643: per_periods_of_service service_period
644: WHERE element.element_type_id = elementtl.element_type_id
645: AND elementtl.language = USERENV('LANG')
646: AND asgt.business_group_id = link.business_group_id
647: AND asgt.business_group_id = element.business_group_id