APPS.FF_DATA_DICT dependencies on HR_S_FUNCTIONS

Line 3351: from hr_s_functions;

3347: CURSOR stu -- Selects all rows from startup entity
3348: IS
3349: select distinct name
3350: , legislation_code c_leg_code
3351: from hr_s_functions;
3352:
3353: CURSOR distinct_function(f_name IN varchar2, c_leg_code IN varchar2)
3354: IS
3355: -- Cursor to select distinct functions

Line 3358: from hr_s_functions

3354: IS
3355: -- Cursor to select distinct functions
3356:
3357: select *
3358: from hr_s_functions
3359: where name = f_name
3360: and nvl(legislation_code, 'X') = nvl(c_leg_code, 'X');
3361:
3362: CURSOR usages(f_id IN number)

Line 3421: from hr_s_functions b

3417:
3418: delete from hr_s_function_context_usages a
3419: where exists
3420: (select null
3421: from hr_s_functions b
3422: where b.function_id = a.function_id
3423: and b.name = stu_rec.name
3424: and nvl(b.legislation_code,'X')=nvl(stu_rec.c_leg_code,'X')
3425: );

Line 3430: from hr_s_functions b

3426:
3427: delete from hr_s_function_parameters a
3428: where exists
3429: (select null
3430: from hr_s_functions b
3431: where b.function_id = a.function_id
3432: and b.name = stu_rec.name
3433: and nvl(b.legislation_code,'X')=nvl(stu_rec.c_leg_code,'X')
3434: );

Line 3437: delete from hr_s_functions

3433: and nvl(b.legislation_code,'X')=nvl(stu_rec.c_leg_code,'X')
3434: );
3435:
3436:
3437: delete from hr_s_functions
3438: where name = stu_rec.name
3439: and nvl(legislation_code,'X')=nvl(stu_rec.c_leg_code,'X');
3440:
3441: ELSE