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 6593: p_cost_base IN pa_cost_bases.cost_base%TYPE

6589: --
6590:
6591: /*
6592: procedure add_adjustment_activity(compiled_set_id IN number,
6593: p_cost_base IN pa_cost_bases.cost_base%TYPE
6594: ,p_cost_plus_structure IN pa_cost_plus_structures.cost_plus_structure%TYPE,
6595: cost_adj_reason IN varchar2,
6596: rev_adj_reason IN varchar2,
6597: inv_adj_reason IN varchar2,

Line 7806: FROM PA_COST_BASES pcb

7802: ,P_Cp_Structure PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7803: )
7804: IS
7805: SELECT pcb.COST_BASE
7806: FROM PA_COST_BASES pcb
7807: WHERE pcb.COST_BASE_TYPE = INDIRECT_COST_CODE
7808: AND nvl(G_MODULE ,'XXX') <> 'NEW_ORG' /*4870539*/
7809: AND EXISTS
7810: (

Line 7822: FROM PA_COST_BASES pcb

7818: AND CBICC.COST_BASE = PCB.COST_BASE
7819: AND CBICC.COST_BASE_TYPE = PCB.COST_BASE_TYPE )
7820: UNION /*4870539 :Added union*/
7821: SELECT pcb.COST_BASE
7822: FROM PA_COST_BASES pcb
7823: WHERE pcb.COST_BASE_TYPE = INDIRECT_COST_CODE
7824: AND nvl(G_MODULE ,'XXX') = 'NEW_ORG'
7825: AND EXISTS
7826: (