APPS.PAY_SIMULATOR_SS_PKG dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 447: FROM fnd_descr_flex_column_usages

443:
444:
445: cursor c_avail_rule is
446: SELECT application_column_name
447: FROM fnd_descr_flex_column_usages
448: WHERE descriptive_flexfield_name = 'Payroll Developer DF'
449: AND descriptive_flex_context_code = 'Global Data Elements'
450: AND END_USER_COLUMN_NAME = 'Modeling Availability Rule';
451:

Line 456: FROM fnd_descr_flex_column_usages

452:
453:
454: cursor c_from_date is
455: SELECT application_column_name
456: FROM fnd_descr_flex_column_usages
457: WHERE descriptive_flexfield_name = 'Payroll Developer DF'
458: AND descriptive_flex_context_code = 'Global Data Elements'
459: AND END_USER_COLUMN_NAME = 'Days After Period Start';
460:

Line 463: FROM fnd_descr_flex_column_usages

459: AND END_USER_COLUMN_NAME = 'Days After Period Start';
460:
461: cursor c_to_date is
462: SELECT application_column_name
463: FROM fnd_descr_flex_column_usages
464: WHERE descriptive_flexfield_name = 'Payroll Developer DF'
465: AND descriptive_flex_context_code = 'Global Data Elements'
466: AND END_USER_COLUMN_NAME = 'Days Before Period End';
467:

Line 470: l_from_date fnd_descr_flex_column_usages.application_column_name%type;

466: AND END_USER_COLUMN_NAME = 'Days Before Period End';
467:
468: c_ref sys_refcursor;
469: c_avail_ref sys_refcursor;
470: l_from_date fnd_descr_flex_column_usages.application_column_name%type;
471: l_to_date fnd_descr_flex_column_usages.application_column_name%type;
472: l_col_rule fnd_descr_flex_column_usages.application_column_name%type;
473: l_check number;
474: l_rule varchar2(10);

Line 471: l_to_date fnd_descr_flex_column_usages.application_column_name%type;

467:
468: c_ref sys_refcursor;
469: c_avail_ref sys_refcursor;
470: l_from_date fnd_descr_flex_column_usages.application_column_name%type;
471: l_to_date fnd_descr_flex_column_usages.application_column_name%type;
472: l_col_rule fnd_descr_flex_column_usages.application_column_name%type;
473: l_check number;
474: l_rule varchar2(10);
475:

Line 472: l_col_rule fnd_descr_flex_column_usages.application_column_name%type;

468: c_ref sys_refcursor;
469: c_avail_ref sys_refcursor;
470: l_from_date fnd_descr_flex_column_usages.application_column_name%type;
471: l_to_date fnd_descr_flex_column_usages.application_column_name%type;
472: l_col_rule fnd_descr_flex_column_usages.application_column_name%type;
473: l_check number;
474: l_rule varchar2(10);
475:
476: BEGIN