APPS.HR_ID_FLEX_INFO dependencies on FND_APPLICATION

Line 7: g_application_short_name1 fnd_application.application_short_name%TYPE;

3: AS
4: --
5: -- Global variables
6: --
7: g_application_short_name1 fnd_application.application_short_name%TYPE;
8: g_id_flex_code1 fnd_id_flexs.id_flex_code%TYPE;
9: g_set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE;
10: g_application_id2 fnd_id_flexs.application_id%TYPE;
11: g_id_flex_code2 fnd_id_flexs.id_flex_code%TYPE;

Line 18: (p_application_short_name IN fnd_application.application_short_name%TYPE

14: -- -----------------------------------------------------------------------------
15: -- |--------------------------< defining_column_name >-------------------------|
16: -- -----------------------------------------------------------------------------
17: FUNCTION defining_column_name
18: (p_application_short_name IN fnd_application.application_short_name%TYPE
19: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
20: )
21: RETURN fnd_id_flexs.set_defining_column_name%TYPE
22: IS

Line 27: (p_application_short_name IN fnd_application.application_short_name%TYPE

23: --
24: -- Local cursors
25: --
26: CURSOR csr_id_flexs
27: (p_application_short_name IN fnd_application.application_short_name%TYPE
28: ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
29: )
30: IS
31: SELECT kfl.set_defining_column_name

Line 33: ,fnd_application app

29: )
30: IS
31: SELECT kfl.set_defining_column_name
32: FROM fnd_id_flexs kfl
33: ,fnd_application app
34: WHERE kfl.application_id = app.application_id
35: AND app.application_short_name = p_application_short_name
36: AND kfl.id_flex_code = p_id_flex_code;
37: --