DBA Data[Home] [Help]

APPS.PQP_GB_AD_EE dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 782: ( SELECT 1 FROM pay_assignment_link_usages_f usage

778: OR link.pay_basis_id IS NULL)
779: AND (link.employment_category = asgt.employment_category
780: OR link.employment_category IS NULL)
781: AND (link.people_group_id IS NULL OR EXISTS
782: ( SELECT 1 FROM pay_assignment_link_usages_f usage
783: WHERE usage.assignment_id = asgt.assignment_id
784: AND usage.element_link_id = link.element_link_id
785: AND p_effective_date
786: BETWEEN usage.effective_start_date