DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 553: ( SELECT 1 FROM pay_assignment_link_usages_f usage

549: AND (link.employment_category = asgt.employment_category
550: OR link.employment_category IS NULL)
551: AND (link.people_group_id IS NULL
552: OR EXISTS
553: ( SELECT 1 FROM pay_assignment_link_usages_f usage
554: WHERE usage.assignment_id = asgt.assignment_id
555: AND usage.element_link_id = link.element_link_id
556: AND cp_effective_date BETWEEN usage.effective_start_date
557: AND usage.effective_end_date))

Line 678: ( SELECT 1 FROM pay_assignment_link_usages_f usage

674: OR link.pay_basis_id IS NULL)
675: AND (link.employment_category = asgt.employment_category
676: OR link.employment_category IS NULL)
677: AND (link.people_group_id IS NULL OR EXISTS
678: ( SELECT 1 FROM pay_assignment_link_usages_f usage
679: WHERE usage.assignment_id = asgt.assignment_id
680: AND usage.element_link_id = link.element_link_id
681: AND cp_effective_date BETWEEN usage.effective_start_date
682: AND usage.effective_end_date))