DBA Data[Home] [Help]

APPS.PAY_TRGL_PKG dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 686: FROM pay_assignment_link_usages_f PAL

682: OR EL1.employment_category IS NULL)
683: AND (EL1.people_group_id IS NULL
684: OR EXISTS
685: (SELECT 1
686: FROM pay_assignment_link_usages_f PAL
687: WHERE PAL.assignment_id = PERA.assignment_id
688: AND PAL.element_link_id = EL1.element_link_id
689: AND ppa.date_earned BETWEEN PAL.effective_start_date
690: AND PAL.effective_end_date))

Line 890: FROM pay_assignment_link_usages_f PAL

886: OR EL1.employment_category IS NULL)
887: AND (EL1.people_group_id IS NULL
888: OR EXISTS
889: (SELECT 1
890: FROM pay_assignment_link_usages_f PAL
891: WHERE PAL.assignment_id = PERA.assignment_id
892: AND PAL.element_link_id = EL1.element_link_id
893: AND ppa.date_earned BETWEEN PAL.effective_start_date
894: AND PAL.effective_end_date))

Line 1778: FROM pay_assignment_link_usages_f PAL

1774: OR EL1.employment_category IS NULL)
1775: AND (EL1.people_group_id IS NULL
1776: OR EXISTS
1777: (SELECT 1
1778: FROM pay_assignment_link_usages_f PAL
1779: WHERE PAL.assignment_id = PERA.assignment_id
1780: AND PAL.element_link_id = EL1.element_link_id
1781: AND ppa.date_earned BETWEEN PAL.effective_start_date
1782: AND PAL.effective_end_date))

Line 1910: FROM pay_assignment_link_usages_f PAL

1906: OR EL1.employment_category IS NULL)
1907: AND (EL1.people_group_id IS NULL
1908: OR EXISTS
1909: (SELECT 1
1910: FROM pay_assignment_link_usages_f PAL
1911: WHERE PAL.assignment_id = PERA.assignment_id
1912: AND PAL.element_link_id = EL1.element_link_id
1913: AND ppa.effective_date BETWEEN PAL.effective_start_date
1914: AND PAL.effective_end_date))