APPS.JAI_DF_DROP dependencies on FND_APPLICATION

Line 30: from fnd_application

26: where flex_value_set_id = cpn_value_set_id;
27:
28: cursor cur_appl_id(cpv_app_short_name varchar2) is
29: select application_id
30: from fnd_application
31: where application_short_name = cpv_app_short_name;
32:
33: /* Added cpn_application_id parameter for bug 4924146 */
34: cursor c_get_dff_details (cpn_application_id number, p_segment_name varchar2) is

Line 505: from fnd_application

501:
502: /* VAT- Dynamic Segments ..could be allocated to any context */
503: /* Added ln_application_id population code for bug 4924146 */
504: select application_id into ln_application_id
505: from fnd_application
506: where application_short_name = 'SQLAP';
507:
508: open c_get_dff_details(ln_application_id, 'VAT Invoice Number'); /* Added appl_id for bug 4924146 */
509: fetch c_get_dff_details into lv_context, lv_attribute_vat_invoice,ln_value_set_inv_id;