[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
1570: from dual
1571: where exists (select null
1572: from hr_s_application_ownerships a
1573: , fnd_product_installations b
1574: , fnd_application c
1575: where a.key_name = 'FORMULA_ID'
1576: and a.key_value = r_distinct.c_surrogate_key
1577: and a.product_name = c.application_short_name
1578: and c.application_id = b.application_id
2443: where exists
2444: (select null
2445: from hr_s_application_ownerships a
2446: , fnd_product_installations b
2447: , fnd_application c
2448: where a.key_name = 'ROUTE_ID'
2449: and a.key_value = stu_rec.c_surrogate_key
2450: and a.product_name = c.application_short_name
2451: and c.application_id = b.application_id
3952: where exists
3953: (select null
3954: from hr_s_application_ownerships a
3955: , fnd_product_installations b
3956: , fnd_application c
3957: where a.key_name = 'QP_REPORT_ID'
3958: and a.key_value = stu_rec.c_surrogate_key
3959: and a.product_name = c.application_short_name
3960: and c.application_id = b.application_id
4651: into l_null_return
4652: from dual
4653: where exists (select null from hr_s_application_ownerships a
4654: , fnd_product_installations b
4655: , fnd_application c
4656: where a.key_name = 'GLOBAL_ID'
4657: and a.key_value = r_distinct.c_surrogate_key
4658: and a.product_name = c.application_short_name
4659: and c.application_id = b.application_id