eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_EXPENDITURES

Line 86: exp_id pa_expenditures_all.expenditure_id%type;

82: -- For debugging messages
83:
84: exp_group pa_expenditure_groups_all.expenditure_group%type;
85: -- expenditure group id for each run of this program
86: exp_id pa_expenditures_all.expenditure_id%type;
87: -- expenditure id of expenditure items
88: x_exp_id pa_expenditures_all.expenditure_id%type;
89: exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
90: exp_org_id pa_expenditure_items_all.organization_id%type;

Line 88: x_exp_id pa_expenditures_all.expenditure_id%type;

84: exp_group pa_expenditure_groups_all.expenditure_group%type;
85: -- expenditure group id for each run of this program
86: exp_id pa_expenditures_all.expenditure_id%type;
87: -- expenditure id of expenditure items
88: x_exp_id pa_expenditures_all.expenditure_id%type;
89: exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
90: exp_org_id pa_expenditure_items_all.organization_id%type;
91: -- expenditure organization/override organization
92: over_project_id pa_projects_all.project_id%type;

Line 166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;

162: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL;
163: l_nl_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL;
164: l_nl_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL;
165: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL;
166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;
167: l_inventory_item_id PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL;
168: l_vendor_id PA_COMMITMENT_TXNS.vendor_id%type default null;
169: l_bom_labor_resource_id PA_COMMITMENT_TXNS.bom_equipment_resource_id%type default null;
170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;

Line 465: pa_expenditures e /3040724/

461: e.person_type person_type,
462: e.incurred_by_person_id
463: from pa_cost_distribution_lines cdl,
464: pa_expenditure_items ei,
465: pa_expenditures e /*3040724*/
466: where cdl.line_type = 'R'
467: and nvl(cdl.amount,0) <> 0
468: and ((cdl.burden_sum_source_run_id >0
469: and cdl.prev_ind_compiled_set_id is NOT NULL) /*2933915*/

Line 1145: pa_expenditures_all e

1141: /* AND cdl.prev_ind_compiled_set_id is NOT NULL :3040724
1142: AND cdl.burden_sum_rejection_code ='IN_PROCESS'
1143: AND cdl.expenditure_item_id in (select ei.expenditure_item_id
1144: from pa_expenditure_items_all ei,
1145: pa_expenditures_all e
1146: where e.expenditure_id =ei.expenditure_id
1147: AND ei.task_id =rec.task_id
1148: AND ei.expenditure_type =rec.expenditure_type
1149: AND ei.expenditure_item_date =rec.expenditure_item_date

Line 1174: from pa_expenditures e,

1170: AND ei.project_id =current_project_id
1171: AND trunc(ei.expenditure_item_date) =trunc(rec.expenditure_item_date)
1172: AND ei.request_id = x_request_id /*2933915
1173: AND exists (select 1
1174: from pa_expenditures e,
1175: pa_cost_distribution_lines cdl
1176: where e.expenditure_id =ei.expenditure_id
1177: AND cdl.expenditure_item_id =ei.expenditure_item_id
1178: AND cdl.burden_sum_rejection_code ='IN_PROCESS'

Line 1194: pa_expenditures_all e

1190: /* AND cdl.prev_ind_compiled_set_id is NOT NULL Commented for 3040724
1191: AND cdl.burden_sum_rejection_code ='IN_PROCESS' /*2993915
1192: AND cdl.expenditure_item_id in (select ei.expenditure_item_id
1193: from pa_expenditure_items_all ei,
1194: pa_expenditures_all e
1195: where e.expenditure_id =ei.expenditure_id
1196: AND ei.task_id =rec.task_id
1197: AND ei.expenditure_type =rec.expenditure_type
1198: AND ei.expenditure_item_date =rec.expenditure_item_date

Line 1501: from pa_expenditures_all

1497: /* Changed this query for Bug# 5406802 */
1498:
1499: select expenditure_id,incurred_by_organization_id
1500: into exp_id,exp_org_id
1501: from pa_expenditures_all
1502: where expenditure_group = exp_group
1503: and incurred_by_organization_id = bcc_rec.source_org_id
1504: and NVL(incurred_by_person_id,-99) = nvl(bcc_rec.source_incurred_by_person_id,-99) -- changes done for 4324340 . Bug 4115096 and added NVL By 4282553
1505: and expenditure_ending_date = l_next_weekend_date; -- Bug 3551106

Line 1526: select pa_expenditures_s.nextval

1522: -- Get new expenditure id
1523: IF P_DEBUG_MODE THEN
1524: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1150:Get Expenditure Id from sequence');
1525: END IF;
1526: select pa_expenditures_s.nextval
1527: into exp_id from dual;
1528: stage := 170; -- Creating burden expenditure
1529:
1530: l_curr_expenditure_id := exp_id ; -- Bug 3551106

Line 2638: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;

2634: l_job_id PA_EXPENDITURE_ITEMS_ALL.job_id%type default null;
2635: l_non_labor_resource PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type default null;
2636: l_non_labor_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type default null;
2637: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type default null;
2638: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type default null;
2639:
2640: ------------ Decalrarion of Cursors ---------------
2641:
2642: -- Cursor to select all the Projects for which there are non-summarized Commitment tran

Line 3320: PA_EXPENDITURES_ALL E

3316: ,CDL.PROJFUNC_COST_EXCHANGE_RATE
3317: FROM
3318: PA_COST_DISTRIBUTION_LINES_ALL CDL,
3319: PA_EXPENDITURE_ITEMS EI,
3320: PA_EXPENDITURES_ALL E
3321: WHERE cdl.burden_sum_source_run_id = p_current_run_id
3322: AND cdl.project_id = p_project_id
3323: AND cdl.expenditure_item_id = ei.expenditure_item_id
3324: AND cdl.line_type = 'R'