APPS.FPA_MAIN_PROCESS_PVT dependencies on FND_PROFILE

Line 87: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST') = PLC.FIN_PLAN_TYPE_ID AND

83: SELECT PLC.NAME, PLB.NAME
84: INTO L_PC_ATTRIBUTES_REC.COST_FIN_PLAN, L_PC_ATTRIBUTES_REC.BENEFIT_FIN_PLAN
85: FROM PA_FIN_PLAN_TYPES_TL PLC, PA_FIN_PLAN_TYPES_TL PLB
86: WHERE
87: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST') = PLC.FIN_PLAN_TYPE_ID AND
88: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = PLB.FIN_PLAN_TYPE_ID AND
89: PLC.LANGUAGE = USERENV('LANG') AND -- Bug Ref # 6450301
90: PLB.LANGUAGE = USERENV('LANG');
91: EXCEPTION

Line 88: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = PLB.FIN_PLAN_TYPE_ID AND

84: INTO L_PC_ATTRIBUTES_REC.COST_FIN_PLAN, L_PC_ATTRIBUTES_REC.BENEFIT_FIN_PLAN
85: FROM PA_FIN_PLAN_TYPES_TL PLC, PA_FIN_PLAN_TYPES_TL PLB
86: WHERE
87: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST') = PLC.FIN_PLAN_TYPE_ID AND
88: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = PLB.FIN_PLAN_TYPE_ID AND
89: PLC.LANGUAGE = USERENV('LANG') AND -- Bug Ref # 6450301
90: PLB.LANGUAGE = USERENV('LANG');
91: EXCEPTION
92: WHEN OTHERS THEN

Line 247: avalue => fnd_profile.value('PJP_PORTFOLIO_CLASS_CATEGORY'));

243:
244: wf_engine.SetItemAttrText(itemtype => l_itemtype,
245: itemkey => l_itemkey,
246: aname => 'FPA_PRTF_SELECTION_CATEGORY',
247: avalue => fnd_profile.value('PJP_PORTFOLIO_CLASS_CATEGORY'));
248:
249: wf_engine.SetItemAttrText(itemtype => l_itemtype,
250: itemkey => l_itemkey,
251: aname => 'FPA_COST_FIN_PLAN_TYPE',

Line 742: organization_structure_id = FND_PROFILE.VALUE('PJP_ORGANIZATION_HIERARCHY')

738: org_structure_version_id into l_pjp_org_version_id
739: from
740: per_org_structure_versions
741: where
742: organization_structure_id = FND_PROFILE.VALUE('PJP_ORGANIZATION_HIERARCHY')
743: and (trunc(sysdate) between trunc(date_from) and trunc(nvl(date_to,
744: sysdate)));
745:
746: select