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_COST_PLUS dependencies on PA_COST_BASE_COST_CODES

Line 68: FROM PA_COST_BASE_COST_CODES CBICC,

64: WHERE pcb.COST_BASE_TYPE = INDIRECT_COST_CODE
65: AND EXISTS
66: (
67: SELECT 1 /* Bug# 4527736 */
68: FROM PA_COST_BASE_COST_CODES CBICC,
69: PA_IND_COST_MULTIPLIERS ICM,
70: PA_IND_RATE_SCH_REVISIONS IRSR
71: WHERE IRSR.IND_RATE_SCH_REVISION_ID = ICM.IND_RATE_SCH_REVISION_ID
72: AND IRSR.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id

Line 129: old_precedence pa_cost_base_cost_codes.precedence%TYPE DEFAULT NULL;

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;
133: l_start_date DATE;

Line 158: FROM pa_cost_base_cost_codes cbicc,

154: cbicc.cost_base_cost_code_id,
155: cbicc.cost_base,
156: cbicc.ind_cost_code,
157: cbicc.precedence
158: FROM pa_cost_base_cost_codes cbicc,
159: pa_ind_rate_sch_revisions irsr
160: WHERE irsr.ind_rate_sch_revision_id = rate_sch_rev_id
161: AND irsr.cost_plus_structure = cbicc.cost_plus_structure
162: AND cbicc.cost_base = x_base -- 2933915

Line 174: FROM pa_cost_base_cost_codes cbicc

170: cbicc.cost_base_cost_code_id,
171: cbicc.cost_base,
172: cbicc.ind_cost_code,
173: cbicc.precedence
174: FROM pa_cost_base_cost_codes cbicc
175: WHERE cbicc.cost_plus_structure = G_CP_STRUCTURE
176: AND cbicc.cost_base = x_base
177: AND cbicc.cost_base_type = INDIRECT_COST_CODE
178: ORDER BY

Line 1233: FROM pa_cost_base_cost_codes

1229: CURSOR all_cost_bases
1230: IS
1231: SELECT
1232: distinct cost_base
1233: FROM pa_cost_base_cost_codes
1234: WHERE cost_plus_structure =l_cp_structure
1235: AND cost_base_type = INDIRECT_COST_CODE ;
1236:
1237: BEGIN

Line 1364: from pa_cost_base_cost_codes cbicc

1360: l_created_by,
1361: SYSDATE,
1362: x_last_update_login,
1363: 'Y'
1364: from pa_cost_base_cost_codes cbicc
1365: where cbicc.cost_plus_structure = G_CP_STRUCTURE /* 4527736 */
1366: and cbicc.cost_base_type = INDIRECT_COST_CODE
1367: and cbicc.ind_cost_code not in (select m.ind_cost_code
1368: from pa_ind_cost_multipliers m

Line 3948: FROM pa_cost_base_cost_codes

3944: SELECT cost_base,
3945: cost_base_type,
3946: ind_cost_code,
3947: precedence
3948: FROM pa_cost_base_cost_codes
3949: WHERE cost_plus_structure = source;
3950:
3951: CURSOR et_cursor
3952: IS

Line 3996: SELECT pa_cost_base_cost_codes_s.nextval into cbicc_id FROM sys.dual;

3992: end if;
3993:
3994:
3995: for icc_row in icc_cursor loop
3996: SELECT pa_cost_base_cost_codes_s.nextval into cbicc_id FROM sys.dual;
3997:
3998: INSERT INTO pa_cost_base_cost_codes
3999: (cost_base_cost_code_id,
4000: cost_plus_structure,

Line 3998: INSERT INTO pa_cost_base_cost_codes

3994:
3995: for icc_row in icc_cursor loop
3996: SELECT pa_cost_base_cost_codes_s.nextval into cbicc_id FROM sys.dual;
3997:
3998: INSERT INTO pa_cost_base_cost_codes
3999: (cost_base_cost_code_id,
4000: cost_plus_structure,
4001: cost_base,
4002: cost_base_type,

Line 4118: FROM pa_cost_base_cost_codes cbicc,

4114: CURSOR mark_impacted_cost_bases --3054111
4115: IS
4116: SELECT
4117: DISTINCT cbicc.cost_base ,cbicc.cost_plus_structure
4118: FROM pa_cost_base_cost_codes cbicc,
4119: pa_ind_cost_multipliers icm
4120: WHERE icm.ind_rate_sch_revision_id = rate_sch_rev_id --3054111
4121: AND (nvl(icm.ready_to_compile_flag,'N') in ('Y','X') OR nvl(G_MODULE,'XXX') ='NEW_ORG')
4122: AND cbicc.cost_plus_structure = l_cp_structure --3054111

Line 7645: FROM pa_cost_base_cost_codes cbicc,

7641: * Repalced with the below sql. Hari 19-JUL-05.
7642: CURSOR impacted_cost_code_cur(x_base VARCHAR2) **Cursor for all the cost codes of impacted cost bases**
7643: IS
7644: SELECT distinct cbicc.ind_cost_code
7645: FROM pa_cost_base_cost_codes cbicc,
7646: pa_ind_rate_sch_revisions irsr
7647: WHERE irsr.ind_rate_sch_revision_id = rate_sch_rev_id
7648: AND irsr.cost_plus_structure = cbicc.cost_plus_structure
7649: AND cbicc.cost_base = x_base

Line 7655: FROM pa_cost_base_cost_codes cbicc

7651: */
7652: CURSOR impacted_cost_code_cur(x_base VARCHAR2) /*Cursor for all the cost codes of impacted cost bases*/
7653: IS
7654: SELECT distinct cbicc.ind_cost_code
7655: FROM pa_cost_base_cost_codes cbicc
7656: WHERE cbicc.cost_plus_structure = G_CP_STRUCTURE
7657: AND cbicc.cost_base = x_base
7658: AND cbicc.cost_base_type = INDIRECT_COST_CODE ;
7659:

Line 7812: FROM PA_COST_BASE_COST_CODES CBICC,

7808: AND nvl(G_MODULE ,'XXX') <> 'NEW_ORG' /*4870539*/
7809: AND EXISTS
7810: (
7811: SELECT 1
7812: FROM PA_COST_BASE_COST_CODES CBICC,
7813: PA_IND_COST_MULTIPLIERS ICM
7814: WHERE ICM.IND_RATE_SCH_REVISION_ID = P_Ind_Rate_Sch_Revision_Id
7815: AND (NVL(ICM.READY_TO_COMPILE_FLAG,'N') IN ('Y','X') AND NVL(G_MODULE ,'XXX') <> 'NEW_ORG')/*4870539*/
7816: AND CBICC.COST_PLUS_STRUCTURE = P_Cp_Structure

Line 7828: FROM PA_COST_BASE_COST_CODES CBICC,

7824: AND nvl(G_MODULE ,'XXX') = 'NEW_ORG'
7825: AND EXISTS
7826: (
7827: SELECT 1
7828: FROM PA_COST_BASE_COST_CODES CBICC,
7829: PA_IND_rate_sch_revisions IRSR
7830: WHERE IRSR.IND_RATE_SCH_REVISION_ID = P_Ind_Rate_Sch_Revision_Id
7831: AND nvl(G_MODULE ,'XXX') = 'NEW_ORG'
7832: AND IRSR.COST_PLUS_STRUCTURE= CBICC.COST_PLUS_STRUCTURE