APPS.PAY_NL_GENERAL dependencies on PAY_OBJECT_GROUPS

Line 1859: FROM pay_object_groups pog1

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'

Line 1860: ,pay_object_groups pog2

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

Line 1879: FROM pay_object_groups pog

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

Line 2044: FROM pay_object_groups pog1

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'

Line 2045: ,pay_object_groups pog2

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

Line 2064: FROM pay_object_groups pog

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

Line 2275: FROM pay_object_groups pog1

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'

Line 2276: ,pay_object_groups pog2

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

Line 2513: FROM pay_object_groups pog1

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'

Line 2514: ,pay_object_groups pog2

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