APPS.HR_LEGISLATION dependencies on FND_APPLICATION

Line 1086: , fnd_application c

1082: where exists (
1083: select null
1084: from hr_s_application_ownerships a
1085: , fnd_product_installations b
1086: , fnd_application c
1087: where a.key_name = 'ASSIGNMENT_STATUS_TYPE_ID'
1088: and a.key_value = l_new_surrogate_key
1089: and a.product_name = c.application_short_name
1090: and c.application_id = b.application_id

Line 2131: , fnd_application c

2127: where exists
2128: (select null
2129: from hr_s_application_ownerships a
2130: , fnd_product_installations b
2131: , fnd_application c
2132: where a.key_name = 'BALANCE_TYPE_ID'
2133: and a.key_value = stu_rec.c_surrogate_key
2134: and a.product_name = c.application_short_name
2135: and c.application_id = b.application_id

Line 2147: , fnd_application c

2143: where exists
2144: (select null
2145: from hr_s_application_ownerships a
2146: , fnd_product_installations b
2147: , fnd_application c
2148: where a.key_name = 'BALANCE_TYPE_ID'
2149: and a.key_value = stu_rec.c_surrogate_key
2150: and a.product_name = c.application_short_name
2151: and c.application_id = b.application_id

Line 3060: , fnd_application c

3056: where exists
3057: (select null
3058: from hr_s_application_ownerships a
3059: , fnd_product_installations b
3060: , fnd_application c
3061: where a.key_name = 'BALANCE_DIMENSION_ID'
3062: and a.key_value = stu_rec.c_surrogate_key
3063: and a.product_name = c.application_short_name
3064: and c.application_id = b.application_id

Line 3076: , fnd_application c

3072: where exists
3073: (select null
3074: from hr_s_application_ownerships a
3075: , fnd_product_installations b
3076: , fnd_application c
3077: where a.key_name = 'BALANCE_DIMENSION_ID'
3078: and a.key_value = stu_rec.c_surrogate_key
3079: and a.product_name = c.application_short_name
3080: and c.application_id = b.application_id

Line 3703: , fnd_application_id

3699: , destination
3700: , displayed_org_information_type doit
3701: , legislation_code
3702: , navigation_method
3703: , fnd_application_id
3704: , rowid
3705: from hr_s_org_information_types;
3706:
3707: stu_rec stu%ROWTYPE; -- Record for above SELECT

Line 3816: ,fnd_application_id

3812: (org_information_type
3813: ,description
3814: ,destination
3815: ,displayed_org_information_type
3816: ,fnd_application_id
3817: ,legislation_code
3818: ,navigation_method
3819: )
3820: values

Line 3825: ,stu_rec.fnd_application_id

3821: (stu_rec.org_information_type
3822: ,stu_rec.description
3823: ,stu_rec.destination
3824: ,stu_rec.doit
3825: ,stu_rec.fnd_application_id
3826: ,stu_rec.legislation_code
3827: ,stu_rec.navigation_method
3828: );
3829:

Line 5050: , fnd_application c

5046: where exists (
5047: select null
5048: from hr_s_application_ownerships a
5049: , fnd_product_installations b
5050: , fnd_application c
5051: where a.key_name = 'USER_ROW_ID'
5052: and a.key_value = r_distinct.c_surrogate_key
5053: and a.product_name = c.application_short_name
5054: and c.application_id = b.application_id

Line 5066: , fnd_application c

5062: where exists (
5063: select null
5064: from hr_s_application_ownerships a
5065: , fnd_product_installations b
5066: , fnd_application c
5067: where a.key_name = 'USER_ROW_ID'
5068: and a.key_value = r_distinct.c_surrogate_key
5069: and a.product_name = c.application_short_name
5070: and c.application_id = b.application_id

Line 5607: , fnd_application c

5603: where exists
5604: (select null
5605: from hr_s_application_ownerships a
5606: , fnd_product_installations b
5607: , fnd_application c
5608: where a.key_name = 'MONETARY_UNIT_ID'
5609: and a.key_value = stu_rec.c_surrogate_key
5610: and a.product_name = c.application_short_name
5611: and c.application_id = b.application_id