APPS.PAY_SIMULATOR_PKG dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 67: FROM fnd_descr_flex_column_usages

63: )RETURN number IS
64:
65: CURSOR c_doc_type is
66: select application_column_name
67: FROM fnd_descr_flex_column_usages
68: WHERE descriptive_flexfield_name = 'Org Developer DF'
69: AND descriptive_flex_context_code = 'HR_SELF_SERVICE_BG_PREFERENCE'
70: AND end_user_column_name = 'Document Type';
71: l_doc_type_col fnd_descr_flex_column_usages.application_column_name%TYPE;

Line 71: l_doc_type_col fnd_descr_flex_column_usages.application_column_name%TYPE;

67: FROM fnd_descr_flex_column_usages
68: WHERE descriptive_flexfield_name = 'Org Developer DF'
69: AND descriptive_flex_context_code = 'HR_SELF_SERVICE_BG_PREFERENCE'
70: AND end_user_column_name = 'Document Type';
71: l_doc_type_col fnd_descr_flex_column_usages.application_column_name%TYPE;
72:
73: CURSOR c_element_set_column_name IS
74: SELECT application_column_name
75: FROM fnd_descr_flex_column_usages

Line 75: FROM fnd_descr_flex_column_usages

71: l_doc_type_col fnd_descr_flex_column_usages.application_column_name%TYPE;
72:
73: CURSOR c_element_set_column_name IS
74: SELECT application_column_name
75: FROM fnd_descr_flex_column_usages
76: WHERE descriptive_flexfield_name = 'Org Developer DF'
77: AND descriptive_flex_context_code = 'HR_SELF_SERVICE_BG_PREFERENCE'
78: AND end_user_column_name = 'Modeling Exclusion Element Set';
79: l_column_name fnd_descr_flex_column_usages.application_column_name%TYPE;

Line 79: l_column_name fnd_descr_flex_column_usages.application_column_name%TYPE;

75: FROM fnd_descr_flex_column_usages
76: WHERE descriptive_flexfield_name = 'Org Developer DF'
77: AND descriptive_flex_context_code = 'HR_SELF_SERVICE_BG_PREFERENCE'
78: AND end_user_column_name = 'Modeling Exclusion Element Set';
79: l_column_name fnd_descr_flex_column_usages.application_column_name%TYPE;
80: c_ref sys_refcursor;
81: l_element_set_id NUMBER;
82:
83: