APPS.HR_LEGISLATION dependencies on FND_APPLICATION

Line 881: , fnd_application c

877: where exists (
878: select null
879: from hr_s_application_ownerships a
880: , fnd_product_installations b
881: , fnd_application c
882: where a.key_name = 'ASSIGNMENT_STATUS_TYPE_ID'
883: and a.key_value = l_new_surrogate_key
884: and a.product_name = c.application_short_name
885: and c.application_id = b.application_id

Line 1914: , fnd_application c

1910: where exists
1911: (select null
1912: from hr_s_application_ownerships a
1913: , fnd_product_installations b
1914: , fnd_application c
1915: where a.key_name = 'BALANCE_TYPE_ID'
1916: and a.key_value = stu_rec.c_surrogate_key
1917: and a.product_name = c.application_short_name
1918: and c.application_id = b.application_id

Line 1930: , fnd_application c

1926: where exists
1927: (select null
1928: from hr_s_application_ownerships a
1929: , fnd_product_installations b
1930: , fnd_application c
1931: where a.key_name = 'BALANCE_TYPE_ID'
1932: and a.key_value = stu_rec.c_surrogate_key
1933: and a.product_name = c.application_short_name
1934: and c.application_id = b.application_id

Line 2814: , fnd_application c

2810: where exists
2811: (select null
2812: from hr_s_application_ownerships a
2813: , fnd_product_installations b
2814: , fnd_application c
2815: where a.key_name = 'BALANCE_DIMENSION_ID'
2816: and a.key_value = stu_rec.c_surrogate_key
2817: and a.product_name = c.application_short_name
2818: and c.application_id = b.application_id

Line 2830: , fnd_application c

2826: where exists
2827: (select null
2828: from hr_s_application_ownerships a
2829: , fnd_product_installations b
2830: , fnd_application c
2831: where a.key_name = 'BALANCE_DIMENSION_ID'
2832: and a.key_value = stu_rec.c_surrogate_key
2833: and a.product_name = c.application_short_name
2834: and c.application_id = b.application_id

Line 3457: , fnd_application_id

3453: , destination
3454: , displayed_org_information_type doit
3455: , legislation_code
3456: , navigation_method
3457: , fnd_application_id
3458: , rowid
3459: from hr_s_org_information_types;
3460:
3461: stu_rec stu%ROWTYPE; -- Record for above SELECT

Line 3570: ,fnd_application_id

3566: (org_information_type
3567: ,description
3568: ,destination
3569: ,displayed_org_information_type
3570: ,fnd_application_id
3571: ,legislation_code
3572: ,navigation_method
3573: )
3574: values

Line 3579: ,stu_rec.fnd_application_id

3575: (stu_rec.org_information_type
3576: ,stu_rec.description
3577: ,stu_rec.destination
3578: ,stu_rec.doit
3579: ,stu_rec.fnd_application_id
3580: ,stu_rec.legislation_code
3581: ,stu_rec.navigation_method
3582: );
3583:

Line 4800: , fnd_application c

4796: where exists (
4797: select null
4798: from hr_s_application_ownerships a
4799: , fnd_product_installations b
4800: , fnd_application c
4801: where a.key_name = 'USER_ROW_ID'
4802: and a.key_value = r_distinct.c_surrogate_key
4803: and a.product_name = c.application_short_name
4804: and c.application_id = b.application_id

Line 4816: , fnd_application c

4812: where exists (
4813: select null
4814: from hr_s_application_ownerships a
4815: , fnd_product_installations b
4816: , fnd_application c
4817: where a.key_name = 'USER_ROW_ID'
4818: and a.key_value = r_distinct.c_surrogate_key
4819: and a.product_name = c.application_short_name
4820: and c.application_id = b.application_id

Line 5357: , fnd_application c

5353: where exists
5354: (select null
5355: from hr_s_application_ownerships a
5356: , fnd_product_installations b
5357: , fnd_application c
5358: where a.key_name = 'MONETARY_UNIT_ID'
5359: and a.key_value = stu_rec.c_surrogate_key
5360: and a.product_name = c.application_short_name
5361: and c.application_id = b.application_id