DBA Data[Home] [Help]

APPS.PAY_TRGL_PKG dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 679: FROM pay_assignment_link_usages_f PAL

675: OR EL1.employment_category IS NULL)
676: AND (EL1.people_group_id IS NULL
677: OR EXISTS
678: (SELECT 1
679: FROM pay_assignment_link_usages_f PAL
680: WHERE PAL.assignment_id = PERA.assignment_id
681: AND PAL.element_link_id = EL1.element_link_id
682: AND ppa.date_earned BETWEEN PAL.effective_start_date
683: AND PAL.effective_end_date))

Line 883: FROM pay_assignment_link_usages_f PAL

879: OR EL1.employment_category IS NULL)
880: AND (EL1.people_group_id IS NULL
881: OR EXISTS
882: (SELECT 1
883: FROM pay_assignment_link_usages_f PAL
884: WHERE PAL.assignment_id = PERA.assignment_id
885: AND PAL.element_link_id = EL1.element_link_id
886: AND ppa.date_earned BETWEEN PAL.effective_start_date
887: AND PAL.effective_end_date))

Line 1759: FROM pay_assignment_link_usages_f PAL

1755: OR EL1.employment_category IS NULL)
1756: AND (EL1.people_group_id IS NULL
1757: OR EXISTS
1758: (SELECT 1
1759: FROM pay_assignment_link_usages_f PAL
1760: WHERE PAL.assignment_id = PERA.assignment_id
1761: AND PAL.element_link_id = EL1.element_link_id
1762: AND ppa.date_earned BETWEEN PAL.effective_start_date
1763: AND PAL.effective_end_date))

Line 1891: FROM pay_assignment_link_usages_f PAL

1887: OR EL1.employment_category IS NULL)
1888: AND (EL1.people_group_id IS NULL
1889: OR EXISTS
1890: (SELECT 1
1891: FROM pay_assignment_link_usages_f PAL
1892: WHERE PAL.assignment_id = PERA.assignment_id
1893: AND PAL.element_link_id = EL1.element_link_id
1894: AND ppa.effective_date BETWEEN PAL.effective_start_date
1895: AND PAL.effective_end_date))