DBA Data[Home] [Help]

APPS.PA_UTILS dependencies on PA_IMPLEMENTATIONS_ALL

Line 1291: FROM pa_implementations_all

1287: INTO x_dummy
1288: FROM sys.dual
1289: WHERE EXISTS (
1290: SELECT NULL
1291: FROM pa_implementations_all
1292: WHERE org_id IS NOT NULL );
1293:
1294: IF ( x_dummy = 'Y' ) THEN
1295: RETURN( 'Y' );

Line 2248: l_org_id pa_implementations_all.org_id%TYPE;

2244: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2245:
2246: l_debug_mode varchar2(1);
2247:
2248: l_org_id pa_implementations_all.org_id%TYPE;
2249: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
2250: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;
2251: l_job_id pa_expenditure_items_all.job_id%TYPE;
2252: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;

Line 2264: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;

2260: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2261: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2262: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2263: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
2264: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2265: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2266: lx_err_stage number;
2267: lx_err_code varchar2(150);
2268:

Line 2379: l_org_id pa_implementations_all.org_id%TYPE;

2375: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2376:
2377: l_debug_mode varchar2(1);
2378:
2379: l_org_id pa_implementations_all.org_id%TYPE;
2380: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
2381: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;
2382: l_job_id pa_expenditure_items_all.job_id%TYPE;
2383: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;

Line 2395: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;

2391: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2392: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2393: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2394: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
2395: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2396: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2397: lx_err_stage number;
2398: lx_err_code varchar2(150);
2399: