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.

APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_FP_ROLLUP_TMP

Line 1256: DELETE pa_fp_rollup_tmp;

1252: -- do not have rejection codes. This applies only to
1253: -- Cost and Revenue Together versions.
1254:
1255: IF p_fp_cols_rec.x_version_type = 'ALL' THEN
1256: DELETE pa_fp_rollup_tmp;
1257: DELETE pa_resource_asgn_curr_tmp;
1258:
1259: -- Use pa_fp_rollup_tmp to get DISTINCT records later.
1260: FORALL i IN 1..l_res_asg_id.count

Line 1259: -- Use pa_fp_rollup_tmp to get DISTINCT records later.

1255: IF p_fp_cols_rec.x_version_type = 'ALL' THEN
1256: DELETE pa_fp_rollup_tmp;
1257: DELETE pa_resource_asgn_curr_tmp;
1258:
1259: -- Use pa_fp_rollup_tmp to get DISTINCT records later.
1260: FORALL i IN 1..l_res_asg_id.count
1261: INSERT INTO pa_fp_rollup_tmp (
1262: RESOURCE_ASSIGNMENT_ID,
1263: TXN_CURRENCY_CODE )

Line 1261: INSERT INTO pa_fp_rollup_tmp (

1257: DELETE pa_resource_asgn_curr_tmp;
1258:
1259: -- Use pa_fp_rollup_tmp to get DISTINCT records later.
1260: FORALL i IN 1..l_res_asg_id.count
1261: INSERT INTO pa_fp_rollup_tmp (
1262: RESOURCE_ASSIGNMENT_ID,
1263: TXN_CURRENCY_CODE )
1264: VALUES (
1265: l_res_asg_id(i),

Line 1284: FROM pa_fp_rollup_tmp) tmp

1280: 0,
1281: 1
1282: FROM pa_budget_lines bl,
1283: (SELECT DISTINCT resource_assignment_id, txn_currency_code
1284: FROM pa_fp_rollup_tmp) tmp
1285: WHERE bl.resource_assignment_id = tmp.resource_assignment_id
1286: AND bl.txn_currency_code = tmp.txn_currency_code
1287: AND bl.budget_version_id = p_budget_version_id
1288: AND bl.cost_rejection_code is null