APPS.CST_EAMCOST_PUB dependencies on PJM_PROJECT_PARAMETERS

Line 3233: FROM pjm_project_parameters ppp

3229: l_stmt_num := 20;
3230:
3231: SELECT NVL(costing_group_id,-1)
3232: INTO l_cost_group_id
3233: FROM pjm_project_parameters ppp
3234: WHERE ppp.project_id = l_wip_project_id
3235: AND ppp.organization_id = l_organization_id;
3236:
3237: IF (l_cost_group_id = -1) THEN

Line 9459: | expenditure type from pjm_project_parameters |

9455: | |
9456: | HISTORY: |
9457: | 06/26/03 Linda Soo Created |
9458: | 08/20/09 Ivan Pineda Added logic for this API to retrieve the |
9459: | expenditure type from pjm_project_parameters |
9460: | or pjm_org_parameters when its not found in |
9461: | in the category associations |
9462: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9463: PROCEDURE get_ExpType_for_DirectItem (

Line 9491: the same time be able to access Pjm_project_parameters

9487: /*+++++++++++++++++++++++++++++++++++++++++++++++++++++++
9488: Added this two parameters for bug 7328006 to retrieve
9489: project_id and o rganization_id in the same access to
9490: wip_transactions to don't hurt the performance and at
9491: the same time be able to access Pjm_project_parameters
9492: and pjm_org_parameters to check if the expenditure type
9493: is defined in there
9494: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9495: l_organization_id NUMBER;

Line 9614: at the pjm_project_parameters table defined for

9610: 1. Look into the category associations to find the exp
9611: type associated with the purchasing category for the
9612: direct item
9613: 2. If 1 is not found then look at the expenditure type
9614: at the pjm_project_parameters table defined for
9615: direct items.
9616: 3. If 2 is not found (like in the case of the common
9617: project) then use the expenditure type at the
9618: pjm_org_parameters table defined for direct items

Line 9658: | pjm_project_parameters |

9654:
9655: /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++
9656: | Check if the expenditure type was not defined in the |
9657: | category associations then try to derive it from |
9658: | pjm_project_parameters |
9659: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9660: l_statement := 90;
9661: if (l_expenditure_type = to_char(-1)) then
9662: if (l_debug = 'Y') THEN

Line 9669: from pjm_project_parameters ppp

9665: end if;
9666: begin
9667: select ppp.dir_item_expenditure_type
9668: into l_expenditure_type
9669: from pjm_project_parameters ppp
9670: where ppp.project_id = l_project_id
9671: and ppp.organization_id = l_organization_id;
9672: exception
9673: when no_data_found then