DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 1584: , PO_SYSTEM_PARAMETERS_ALL PARAMS

1580: l_header_id_tbl
1581: , l_segment1_tbl
1582: FROM
1583: PO_SESSION_GT SES
1584: , PO_SYSTEM_PARAMETERS_ALL PARAMS
1585: , PO_DOC_STYLE_HEADERS PDSH
1586: WHERE
1587: SES.key = l_data_key
1588: AND SES.num2 = PARAMS.org_id

Line 1732: PO_SYSTEM_PARAMETERS_ALL PARAMS

1728: , p_org_id_tbl(i)
1729: , p_segment1_tbl(i)
1730: , p_type_lookup_code_tbl(i)
1731: FROM
1732: PO_SYSTEM_PARAMETERS_ALL PARAMS
1733: WHERE
1734: PARAMS.org_id = p_org_id_tbl(i)
1735: AND PARAMS.user_defined_po_num_code = c_MANUAL
1736: AND p_segment1_tbl(i) IS NOT NULL

Line 2310: PO_SYSTEM_PARAMETERS_ALL

2306: , p_header_id_tbl(i)
2307: , PO_MESSAGE_S.PO_ALL_NOT_NULL
2308: , c_SEGMENT1
2309: FROM
2310: PO_SYSTEM_PARAMETERS_ALL
2311: WHERE
2312: org_id = p_org_id_tbl(i)
2313: AND USER_DEFINED_PO_NUM_CODE = c_MANUAL
2314: AND p_segment1_tbl(i) IS NULL;