DBA Data[Home] [Help]

APPS.PA_COST_PLUS dependencies on PA_COST_BASES

Line 63: FROM PA_COST_BASES pcb

59:
60: CURSOR impacted_cost_bases(rate_sch_rev_id NUMBER)
61: IS
62: SELECT pcb.COST_BASE
63: FROM PA_COST_BASES pcb
64: WHERE pcb.COST_BASE_TYPE = INDIRECT_COST_CODE
65: AND EXISTS
66: (
67: SELECT 1 /* Bug# 4527736 */

Line 128: old_cost_base pa_cost_bases.cost_base%TYPE DEFAULT NULL;

124:
125: base pa_compiled_multipliers.compiled_multiplier%TYPE;
126: defined_org_id hr_organization_units.organization_id%TYPE;
127: ind_cost_multiplier pa_ind_cost_multipliers.multiplier%TYPE;
128: old_cost_base pa_cost_bases.cost_base%TYPE DEFAULT NULL;
129: old_precedence pa_cost_base_cost_codes.precedence%TYPE DEFAULT NULL;
130: ind_cost_multiplier_sum pa_ind_cost_multipliers.multiplier%TYPE;
131: compiled_set_id pa_ind_compiled_sets.ind_compiled_set_id%TYPE;
132: org_override NUMBER(15) DEFAULT 0;

Line 6366: p_cost_base IN pa_cost_bases.cost_base%TYPE

6362: --
6363:
6364: /*
6365: procedure add_adjustment_activity(compiled_set_id IN number,
6366: p_cost_base IN pa_cost_bases.cost_base%TYPE
6367: ,p_cost_plus_structure IN pa_cost_plus_structures.cost_plus_structure%TYPE,
6368: cost_adj_reason IN varchar2,
6369: rev_adj_reason IN varchar2,
6370: inv_adj_reason IN varchar2,

Line 7537: FROM PA_COST_BASES pcb

7533: ,P_Cp_Structure PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7534: )
7535: IS
7536: SELECT pcb.COST_BASE
7537: FROM PA_COST_BASES pcb
7538: WHERE pcb.COST_BASE_TYPE = INDIRECT_COST_CODE
7539: AND nvl(G_MODULE ,'XXX') <> 'NEW_ORG' /*4870539*/
7540: AND EXISTS
7541: (

Line 7553: FROM PA_COST_BASES pcb

7549: AND CBICC.COST_BASE = PCB.COST_BASE
7550: AND CBICC.COST_BASE_TYPE = PCB.COST_BASE_TYPE )
7551: UNION /*4870539 :Added union*/
7552: SELECT pcb.COST_BASE
7553: FROM PA_COST_BASES pcb
7554: WHERE pcb.COST_BASE_TYPE = INDIRECT_COST_CODE
7555: AND nvl(G_MODULE ,'XXX') = 'NEW_ORG'
7556: AND EXISTS
7557: (