APPS.PA_ADJUSTMENTS dependencies on PA_EXPENDITURE_TYPES

Line 2956: from pa_expenditure_types

2952: End If;
2953: Else
2954: select cost_rate_flag
2955: into l_cost_rate_flag
2956: from pa_expenditure_types
2957: where expenditure_type = l_exp_type;
2958:
2959: If l_cost_rate_flag = 'Y' Then
2960: If l_acct_currency_code = l_denom_currency_code Then

Line 3650: from pa_expenditure_types

3646: End If;
3647: Else
3648: select cost_rate_flag
3649: into l_cost_rate_flag
3650: from pa_expenditure_types
3651: where expenditure_type = l_exp_type;
3652:
3653: If l_cost_rate_flag = 'Y' Then
3654: If l_acct_currency_code = l_denom_currency_code Then

Line 4206: pa_expenditure_types et

4202: /* commented the following lines for mfg changes and added the one line above
4203: OR EXISTS
4204: ( SELECT NULL
4205: FROM
4206: pa_expenditure_types et
4207: WHERE
4208: et.expenditure_type = ei.expenditure_type
4209: AND ei.system_linkage_function = X_system_linkage ))
4210: */

Line 5573: || ' FROM pa_expenditure_types et'

5569: end if;
5570:
5571: if x_expenditure_catg is not null then
5572: where_clause := where_clause || ' AND 1 = (SELECT 1'
5573: || ' FROM pa_expenditure_types et'
5574: || ' WHERE et.expenditure_type = ei.expenditure_type'
5575: || ' AND et.expenditure_category = :expenditure_catg)';
5576: end if;
5577:

Line 9369: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;

9365:
9366: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9367: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9368: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9369: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9370: l_job_id pa_expenditure_items_all.job_id%TYPE;
9371: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
9372: l_cost_rate pa_bill_rates_all.rate%TYPE;
9373: l_start_date Date;

Line 9404: FROM pa_expenditure_types

9400: /* Get the cost_rate_flag */
9401: BEGIN
9402: SELECT cost_rate_flag
9403: INTO l_cost_rate_flag
9404: FROM pa_expenditure_types
9405: WHERE expenditure_type = p_exp_type;
9406:
9407: EXCEPTION
9408: WHEN NO_DATA_FOUND THEN