APPS.PA_COST_PLUS1 dependencies on PA_IND_COMPILED_SETS

Line 34: | Added Cost Base join to pa_ind_compiled_sets |

30: status := 0;
31: stage := 100;
32: /*========================================================+
33: | 21-MAY-03 Burdening Enhancements. |
34: | Added Cost Base join to pa_ind_compiled_sets |
35: +========================================================*/
36: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
37: l_projfunc_currency_code)),
38: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),

Line 47: FROM pa_ind_compiled_sets ics,

43: into indirect_cost_sum,
44: indirect_cost_denom_sum,
45: indirect_cost_acct_sum,
46: indirect_cost_project_sum
47: FROM pa_ind_compiled_sets ics,
48: pa_compiled_multipliers icpm
49: WHERE
50: ics.ind_rate_sch_revision_id = rate_sch_rev_id
51: AND ics.organization_id = org_id

Line 553: | Added Cost Base join to pa_ind_compiled_sets |

549:
550: begin
551: /*========================================================+
552: | 21-MAY-03 Burdening Enhancements. |
553: | Added Cost Base join to pa_ind_compiled_sets |
554: +========================================================*/
555: select ind_compiled_set_id
556: into x_ind_compiled_set_id
557: from pa_ind_compiled_sets

Line 557: from pa_ind_compiled_sets

553: | Added Cost Base join to pa_ind_compiled_sets |
554: +========================================================*/
555: select ind_compiled_set_id
556: into x_ind_compiled_set_id
557: from pa_ind_compiled_sets
558: where ind_rate_sch_revision_id = x_rate_sch_rev_id
559: and organization_id = x_organization_id
560: and cost_base = x_cost_base
561: and status = 'A';