APPS.PA_ADJUSTMENTS dependencies on PA_EXPENDITURE_TYPES

Line 3015: from pa_expenditure_types

3011: End If;
3012: Else
3013: select cost_rate_flag
3014: into l_cost_rate_flag
3015: from pa_expenditure_types
3016: where expenditure_type = l_exp_type;
3017:
3018: If l_cost_rate_flag = 'Y' Then
3019: If l_acct_currency_code = l_denom_currency_code Then

Line 3744: from pa_expenditure_types

3740: End If;
3741: Else
3742: select cost_rate_flag
3743: into l_cost_rate_flag
3744: from pa_expenditure_types
3745: where expenditure_type = l_exp_type;
3746:
3747: If l_cost_rate_flag = 'Y' Then
3748: If l_acct_currency_code = l_denom_currency_code Then

Line 4316: pa_expenditure_types et

4312: /* commented the following lines for mfg changes and added the one line above
4313: OR EXISTS
4314: ( SELECT NULL
4315: FROM
4316: pa_expenditure_types et
4317: WHERE
4318: et.expenditure_type = ei.expenditure_type
4319: AND ei.system_linkage_function = X_system_linkage ))
4320: */

Line 5703: || ' FROM pa_expenditure_types et'

5699: end if;
5700:
5701: if x_expenditure_catg is not null then
5702: where_clause := where_clause || ' AND 1 = (SELECT 1'
5703: || ' FROM pa_expenditure_types et'
5704: || ' WHERE et.expenditure_type = ei.expenditure_type'
5705: || ' AND et.expenditure_category = :expenditure_catg)';
5706: end if;
5707:

Line 9652: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;

9648:
9649: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9650: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9651: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9652: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9653: l_job_id pa_expenditure_items_all.job_id%TYPE;
9654: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
9655: l_cost_rate pa_bill_rates_all.rate%TYPE;
9656: l_start_date Date;

Line 9687: FROM pa_expenditure_types

9683: /* Get the cost_rate_flag */
9684: BEGIN
9685: SELECT cost_rate_flag
9686: INTO l_cost_rate_flag
9687: FROM pa_expenditure_types
9688: WHERE expenditure_type = p_exp_type;
9689:
9690: EXCEPTION
9691: WHEN NO_DATA_FOUND THEN