1855: ,c_start_date DATE
1856: ,c_end_date DATE) IS
1857: SELECT distinct pog2.parent_object_group_id parent_id
1858: ,pog2.source_id assignment_id
1859: FROM pay_object_groups pog1
1860: ,pay_object_groups pog2
1861: WHERE pog1.source_id = c_assignment_id
1862: AND pog1.source_type = pog2.source_type
1863: AND pog1.source_type = 'PAF'
1856: ,c_end_date DATE) IS
1857: SELECT distinct pog2.parent_object_group_id parent_id
1858: ,pog2.source_id assignment_id
1859: FROM pay_object_groups pog1
1860: ,pay_object_groups pog2
1861: WHERE pog1.source_id = c_assignment_id
1862: AND pog1.source_type = pog2.source_type
1863: AND pog1.source_type = 'PAF'
1864: AND pog1.parent_object_group_id = pog2.parent_object_group_id
1875: ,c_eff_date DATE) IS
1876: SELECT 'Y'
1877: FROM dual
1878: WHERE exists (SELECT 1
1879: FROM pay_object_groups pog
1880: ,pay_element_entries_f peef
1881: ,pay_element_types_f petf
1882: WHERE pog.parent_object_group_id = c_parent_id
1883: AND peef.assignment_id = pog.source_id
2040: ,c_start_date DATE
2041: ,c_end_date DATE) IS
2042: SELECT distinct pog2.parent_object_group_id parent_id
2043: ,pog2.source_id assignment_id
2044: FROM pay_object_groups pog1
2045: ,pay_object_groups pog2
2046: WHERE pog1.source_id = c_assignment_id
2047: AND pog1.source_type = pog2.source_type
2048: AND pog1.source_type = 'PAF'
2041: ,c_end_date DATE) IS
2042: SELECT distinct pog2.parent_object_group_id parent_id
2043: ,pog2.source_id assignment_id
2044: FROM pay_object_groups pog1
2045: ,pay_object_groups pog2
2046: WHERE pog1.source_id = c_assignment_id
2047: AND pog1.source_type = pog2.source_type
2048: AND pog1.source_type = 'PAF'
2049: AND pog1.parent_object_group_id = pog2.parent_object_group_id
2060: ,c_eff_date DATE) IS
2061: SELECT 'Y'
2062: FROM dual
2063: WHERE exists (SELECT 1
2064: FROM pay_object_groups pog
2065: ,pay_element_entries_f peef
2066: ,pay_element_types_f petf
2067: WHERE pog.parent_object_group_id = c_parent_id
2068: AND peef.assignment_id = pog.source_id
2271: ,c_start_date DATE
2272: ,c_end_date DATE) IS
2273: SELECT '1' FROM DUAL
2274: WHERE EXISTS (SELECT 1
2275: FROM pay_object_groups pog1
2276: ,pay_object_groups pog2
2277: WHERE pog1.source_id = c_assignment_id
2278: AND pog1.source_type = pog2.source_type
2279: AND pog1.source_type = 'PAF'
2272: ,c_end_date DATE) IS
2273: SELECT '1' FROM DUAL
2274: WHERE EXISTS (SELECT 1
2275: FROM pay_object_groups pog1
2276: ,pay_object_groups pog2
2277: WHERE pog1.source_id = c_assignment_id
2278: AND pog1.source_type = pog2.source_type
2279: AND pog1.source_type = 'PAF'
2280: AND pog1.parent_object_group_id = pog2.parent_object_group_id
2509: ,c_start_date DATE
2510: ,c_end_date DATE) IS
2511: SELECT '1' FROM DUAL
2512: WHERE EXISTS (SELECT 1
2513: FROM pay_object_groups pog1
2514: ,pay_object_groups pog2
2515: WHERE pog1.source_id = c_assignment_id
2516: AND pog1.source_type = pog2.source_type
2517: AND pog1.source_type = 'PAF'
2510: ,c_end_date DATE) IS
2511: SELECT '1' FROM DUAL
2512: WHERE EXISTS (SELECT 1
2513: FROM pay_object_groups pog1
2514: ,pay_object_groups pog2
2515: WHERE pog1.source_id = c_assignment_id
2516: AND pog1.source_type = pog2.source_type
2517: AND pog1.source_type = 'PAF'
2518: AND pog1.parent_object_group_id = pog2.parent_object_group_id