APPS.PA_CHECK_COMMITMENTS dependencies on PJM_ORG_PARAMETERS

Line 14: FROM pjm_org_parameters

10: /* Added for bug 4360855 */
11: tmp NUMBER;
12: CURSOR c IS
13: SELECT organization_id
14: FROM pjm_org_parameters
15: WHERE common_project_id = p_ProjectID ;
16:
17: Cursor is_cash_basis_enabled_cur IS /* Bug#4905546 */
18: SELECT 'Y' /* to find whether cash basis accounting is enabled or not */

Line 808: FROM dual where exists (select 1 from pjm_org_parameters

804: );*/
805: /* Bug 5517898 */
806: SELECT 1 -- common project
807: INTO tmp
808: FROM dual where exists (select 1 from pjm_org_parameters
809: WHERE common_project_id = p_ProjectID);
810: /* Bug 5517898 */
811:
812: FOR c_rec in c loop

Line 827: , PJM_ORG_PARAMETERS POP

823: RL.LINE_NUM,
824: RD.DISTRIBUTION_ID
825: FROM PO_REQ_DISTRIBUTIONS_ALL RD
826: , PO_REQUISITION_LINES_ALL RL
827: , PJM_ORG_PARAMETERS POP
828: , MTL_SYSTEM_ITEMS MSI
829: , MTL_UNITS_OF_MEASURE_VL UOM
830: WHERE RL.DESTINATION_TYPE_CODE = 'INVENTORY'
831: AND RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID

Line 845: , PJM_ORG_PARAMETERS POP

841: RL.LINE_NUM,
842: RD.DISTRIBUTION_ID
843: FROM PO_REQ_DISTRIBUTIONS_ALL RD
844: , PO_REQUISITION_LINES_ALL RL
845: , PJM_ORG_PARAMETERS POP
846: , WIP_DISCRETE_JOBS WDJ
847: , WIP_OPERATIONS WO
848: , BOM_DEPARTMENTS BD
849: , MTL_UNITS_OF_MEASURE_VL UOM

Line 1039: FROM dual where exists (select 1 from pjm_org_parameters

1035: );*/
1036: /* Bug 5517898 */
1037: SELECT 1 -- common project
1038: INTO tmp
1039: FROM dual where exists (select 1 from pjm_org_parameters
1040: WHERE common_project_id = p_ProjectID);
1041: /* Bug 5517898 */
1042: FOR c_rec in c loop
1043: Begin

Line 1057: , PJM_ORG_PARAMETERS POP

1053: POL.LINE_NUM,
1054: POD.PO_DISTRIBUTION_ID
1055: FROM PO_DISTRIBUTIONS_ALL POD
1056: , PO_LINES_ALL POL
1057: , PJM_ORG_PARAMETERS POP
1058: , MTL_SYSTEM_ITEMS MSI
1059: , MTL_UNITS_OF_MEASURE_VL UOM
1060: WHERE POD.DESTINATION_TYPE_CODE = 'INVENTORY'
1061: AND POL.PO_LINE_ID = POD.PO_LINE_ID

Line 1075: , PJM_ORG_PARAMETERS POP

1071: POL.LINE_NUM,
1072: POD.PO_DISTRIBUTION_ID
1073: FROM PO_DISTRIBUTIONS_ALL POD
1074: , PO_LINES_ALL POL
1075: , PJM_ORG_PARAMETERS POP
1076: , WIP_DISCRETE_JOBS WDJ
1077: , WIP_OPERATIONS WO
1078: , BOM_DEPARTMENTS BD
1079: , MTL_UNITS_OF_MEASURE_VL UOM