APPS.PAY_AC_ACTION_ARCH dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 2187: FROM FND_DESCR_FLEX_COL_USAGE_VL

2183: replacing table with FND_DESCR_FLEX_COLUMN_USAGES
2184: translation should not be an issue for US leg
2185:
2186: SELECT application_column_name
2187: FROM FND_DESCR_FLEX_COL_USAGE_VL
2188: WHERE end_user_column_name = 'Originating Pay Period'
2189: AND upper(descriptive_flexfield_name) = upper('PAY_ELEMENT_ENTRIES')
2190: AND upper(descriptive_flex_context_code) = 'US EARNINGS';
2191: */

Line 2473: FROM fnd_descr_flex_col_usage_vl fdv

2469: ||' AND '
2470: ||' TO_DATE( :date_earned , ''DD-MON-YYYY'') '
2471: ||' BETWEEN effective_start_date AND effective_end_date '
2472: into lv_sqlstr
2473: FROM fnd_descr_flex_col_usage_vl fdv
2474: WHERE fdv.application_id = 801
2475: AND fdv.descriptive_flexfield_name LIKE 'PAY_ELEMENT_ENTRIES'
2476: AND fdv.descriptive_flex_context_code = 'US EARNINGS';
2477:

Line 2494: FROM fnd_descr_flex_col_usage_vl fdv

2490: ||' :assignment_id AND peef.element_type_id = :element_type_id '
2491: || ' AND NVL(ppa.date_earned, ppa.effective_date)
2492: BETWEEN peef.effective_start_date AND peef.effective_end_date AND peef.'||fdv.application_column_name||' is not null'
2493: into lv_sqlstr1
2494: FROM fnd_descr_flex_col_usage_vl fdv
2495: WHERE fdv.application_id = 801
2496: AND fdv.descriptive_flexfield_name LIKE 'PAY_ELEMENT_ENTRIES'
2497: AND fdv.descriptive_flex_context_code = 'US EARNINGS';
2498:

Line 2515: FROM fnd_descr_flex_col_usage_vl fdv

2511: peef.assignment_id = :assignment_id AND peef.element_type_id =
2512: :element_type_id AND NVL(ppa.date_earned, ppa.effective_date) BETWEEN
2513: peef.effective_start_date AND peef.effective_end_date AND peef.' || fdv.application_column_name || ' is not null '
2514: INTO lv_sqlstr_final
2515: FROM fnd_descr_flex_col_usage_vl fdv
2516: WHERE fdv.application_id = 801
2517: AND fdv.descriptive_flexfield_name LIKE 'PAY_ELEMENT_ENTRIES'
2518: AND fdv.descriptive_flex_context_code = 'US EARNINGS';
2519:

Line 2529: FROM fnd_descr_flex_col_usage_vl fdv

2525: BEGIN
2526: SELECT 'select nvl('|| fdv.application_column_name || ',''AAA'')
2527: from pay_element_entries_f where element_entry_id = :element_entry_id '
2528: into lv_sqlstr_date
2529: FROM fnd_descr_flex_col_usage_vl fdv
2530: WHERE fdv.application_id = 801
2531: AND fdv.descriptive_flexfield_name LIKE 'PAY_ELEMENT_ENTRIES'
2532: AND fdv.descriptive_flex_context_code = 'US EARNINGS';
2533: