APPS.PA_CONTROL_API_PUB dependencies on PA_LOOKUPS

Line 2447: l_source_type_name pa_lookups.meaning%type;

2443: l_priority_code pa_control_items.priority_code%type;
2444: l_effort_level_code pa_control_items.effort_level_code%type;
2445: l_price pa_control_items.price%type;
2446: l_price_currency_code pa_control_items.price_currency_code%type;
2447: l_source_type_name pa_lookups.meaning%type;
2448: l_source_type_code pa_control_items.source_type_code%type;
2449: l_source_number pa_control_items.source_number%type;
2450: l_source_comment pa_control_items.source_comment%type;
2451: l_source_date_received pa_control_items.source_date_received%type;

Line 3082: l_source_type_name pa_lookups.meaning%type;

3078: l_priority_code pa_control_items.priority_code%type;
3079: l_effort_level_code pa_control_items.effort_level_code%type;
3080: l_price pa_control_items.price%type;
3081: l_price_currency_code pa_control_items.price_currency_code%type;
3082: l_source_type_name pa_lookups.meaning%type;
3083: l_source_type_code pa_control_items.source_type_code%type;
3084: l_source_number pa_control_items.source_number%type;
3085: l_source_comment pa_control_items.source_comment%type;
3086: l_source_date_received pa_control_items.source_date_received%type;

Line 3717: l_source_type_name pa_lookups.meaning%type;

3713: l_priority_code pa_control_items.priority_code%type;
3714: l_effort_level_code pa_control_items.effort_level_code%type;
3715: l_price pa_control_items.price%type;
3716: l_price_currency_code pa_control_items.price_currency_code%type;
3717: l_source_type_name pa_lookups.meaning%type;
3718: l_source_type_code pa_control_items.source_type_code%type;
3719: l_source_number pa_control_items.source_number%type;
3720: l_source_comment pa_control_items.source_comment%type;
3721: l_source_date_received pa_control_items.source_date_received%type;

Line 6651: FROM pa_lookups

6647: WHERE project_status_code = p_curr_status_code;
6648:
6649: CURSOR c_lkup (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
6650: SELECT lookup_code
6651: FROM pa_lookups
6652: WHERE lookup_type = p_lookup_type
6653: AND trunc(sysdate) BETWEEN start_date_active AND nvl(end_date_active, trunc(sysdate))
6654: AND enabled_flag = 'Y'
6655: AND lookup_code = p_lookup_code;

Line 7911: FROM pa_lookups

7907: WHERE project_status_code = p_curr_status_code;
7908:
7909: CURSOR c_lkup (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
7910: SELECT lookup_code
7911: FROM pa_lookups
7912: WHERE lookup_type = p_lookup_type
7913: AND trunc(sysdate) BETWEEN start_date_active AND nvl(end_date_active, trunc(sysdate))
7914: AND enabled_flag = 'Y'
7915: AND lookup_code = p_lookup_code;

Line 9168: FROM pa_lookups

9164: WHERE project_status_code = p_curr_status_code;
9165:
9166: CURSOR c_lkup (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
9167: SELECT lookup_code
9168: FROM pa_lookups
9169: WHERE lookup_type = p_lookup_type
9170: AND trunc(sysdate) BETWEEN start_date_active AND nvl(end_date_active, trunc(sysdate))
9171: AND enabled_flag = 'Y'
9172: AND lookup_code = p_lookup_code;