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 3918: FROM pa_cost_base_cost_codes

3914: SELECT cost_base,
3915: cost_base_type,
3916: ind_cost_code,
3917: precedence
3918: FROM pa_cost_base_cost_codes
3919: WHERE cost_plus_structure = source;
3920:
3921: CURSOR et_cursor
3922: IS

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

3962: end if;
3963:
3964:
3965: for icc_row in icc_cursor loop
3966: SELECT pa_cost_base_cost_codes_s.nextval into cbicc_id FROM sys.dual;
3967:
3968: INSERT INTO pa_cost_base_cost_codes
3969: (cost_base_cost_code_id,
3970: cost_plus_structure,

Line 3968: INSERT INTO pa_cost_base_cost_codes

3964:
3965: for icc_row in icc_cursor loop
3966: SELECT pa_cost_base_cost_codes_s.nextval into cbicc_id FROM sys.dual;
3967:
3968: INSERT INTO pa_cost_base_cost_codes
3969: (cost_base_cost_code_id,
3970: cost_plus_structure,
3971: cost_base,
3972: cost_base_type,

Line 4088: FROM pa_cost_base_cost_codes cbicc,

4084: CURSOR mark_impacted_cost_bases --3054111
4085: IS
4086: SELECT
4087: DISTINCT cbicc.cost_base ,cbicc.cost_plus_structure
4088: FROM pa_cost_base_cost_codes cbicc,
4089: pa_ind_cost_multipliers icm
4090: WHERE icm.ind_rate_sch_revision_id = rate_sch_rev_id --3054111
4091: AND (nvl(icm.ready_to_compile_flag,'N') in ('Y','X') OR nvl(G_MODULE,'XXX') ='NEW_ORG')
4092: AND cbicc.cost_plus_structure = l_cp_structure --3054111

Line 7418: FROM pa_cost_base_cost_codes cbicc,

7414: * Repalced with the below sql. Hari 19-JUL-05.
7415: CURSOR impacted_cost_code_cur(x_base VARCHAR2) **Cursor for all the cost codes of impacted cost bases**
7416: IS
7417: SELECT distinct cbicc.ind_cost_code
7418: FROM pa_cost_base_cost_codes cbicc,
7419: pa_ind_rate_sch_revisions irsr
7420: WHERE irsr.ind_rate_sch_revision_id = rate_sch_rev_id
7421: AND irsr.cost_plus_structure = cbicc.cost_plus_structure
7422: AND cbicc.cost_base = x_base

Line 7428: FROM pa_cost_base_cost_codes cbicc

7424: */
7425: CURSOR impacted_cost_code_cur(x_base VARCHAR2) /*Cursor for all the cost codes of impacted cost bases*/
7426: IS
7427: SELECT distinct cbicc.ind_cost_code
7428: FROM pa_cost_base_cost_codes cbicc
7429: WHERE cbicc.cost_plus_structure = G_CP_STRUCTURE
7430: AND cbicc.cost_base = x_base
7431: AND cbicc.cost_base_type = INDIRECT_COST_CODE ;
7432:

Line 7543: FROM PA_COST_BASE_COST_CODES CBICC,

7539: AND nvl(G_MODULE ,'XXX') <> 'NEW_ORG' /*4870539*/
7540: AND EXISTS
7541: (
7542: SELECT 1
7543: FROM PA_COST_BASE_COST_CODES CBICC,
7544: PA_IND_COST_MULTIPLIERS ICM
7545: WHERE ICM.IND_RATE_SCH_REVISION_ID = P_Ind_Rate_Sch_Revision_Id
7546: AND (NVL(ICM.READY_TO_COMPILE_FLAG,'N') IN ('Y','X') AND NVL(G_MODULE ,'XXX') <> 'NEW_ORG')/*4870539*/
7547: AND CBICC.COST_PLUS_STRUCTURE = P_Cp_Structure

Line 7559: FROM PA_COST_BASE_COST_CODES CBICC,

7555: AND nvl(G_MODULE ,'XXX') = 'NEW_ORG'
7556: AND EXISTS
7557: (
7558: SELECT 1
7559: FROM PA_COST_BASE_COST_CODES CBICC,
7560: PA_IND_rate_sch_revisions IRSR
7561: WHERE IRSR.IND_RATE_SCH_REVISION_ID = P_Ind_Rate_Sch_Revision_Id
7562: AND nvl(G_MODULE ,'XXX') = 'NEW_ORG'
7563: AND IRSR.COST_PLUS_STRUCTURE= CBICC.COST_PLUS_STRUCTURE