[Home] [Help]
331: where exists (
332: select null
333: from hr_s_application_ownerships a
334: , fnd_product_installations b
335: , fnd_application c
336: where a.key_name = 'CONTEXT_ID'
337: and a.key_value = l_new_surrogate_key
338: and a.product_name = c.application_short_name
339: and c.application_id = b.application_id
699: where exists (
700: select null
701: from hr_s_application_ownerships a
702: , fnd_product_installations b
703: , fnd_application c
704: where a.key_name = 'FORMULA_TYPE_ID'
705: and a.key_value = l_new_surrogate_key
706: and a.product_name = c.application_short_name
707: and c.application_id = b.application_id
1556: from dual
1557: where exists (select null
1558: from hr_s_application_ownerships a
1559: , fnd_product_installations b
1560: , fnd_application c
1561: where a.key_name = 'FORMULA_ID'
1562: and a.key_value = r_distinct.c_surrogate_key
1563: and a.product_name = c.application_short_name
1564: and c.application_id = b.application_id
2417: where exists
2418: (select null
2419: from hr_s_application_ownerships a
2420: , fnd_product_installations b
2421: , fnd_application c
2422: where a.key_name = 'ROUTE_ID'
2423: and a.key_value = stu_rec.c_surrogate_key
2424: and a.product_name = c.application_short_name
2425: and c.application_id = b.application_id
3901: where exists
3902: (select null
3903: from hr_s_application_ownerships a
3904: , fnd_product_installations b
3905: , fnd_application c
3906: where a.key_name = 'QP_REPORT_ID'
3907: and a.key_value = stu_rec.c_surrogate_key
3908: and a.product_name = c.application_short_name
3909: and c.application_id = b.application_id
4600: into l_null_return
4601: from dual
4602: where exists (select null from hr_s_application_ownerships a
4603: , fnd_product_installations b
4604: , fnd_application c
4605: where a.key_name = 'GLOBAL_ID'
4606: and a.key_value = r_distinct.c_surrogate_key
4607: and a.product_name = c.application_short_name
4608: and c.application_id = b.application_id