APPS.CSTPAVCP dependencies on CST_ORGANIZATION_DEFINITIONS

Line 5859: because we now have to refer CST_ORGANIZATION_DEFINITIONS as a result of the

5855: END IF;
5856: l_stmt_num := 10;
5857:
5858: /* The following FROM clause in the select statement has been commented out
5859: because we now have to refer CST_ORGANIZATION_DEFINITIONS as a result of the
5860: impact of the HR-PROFILE option */
5861:
5862: select set_of_books_id
5863: into l_snd_sob_id

Line 5865: from cst_organization_definitions

5861:
5862: select set_of_books_id
5863: into l_snd_sob_id
5864: /*from org_organization_definitions */
5865: from cst_organization_definitions
5866: where organization_id = i_from_org;
5867:
5868: l_stmt_num := 20;
5869:

Line 5878: commented out because it will now be refering to cst_organization_definitions as an impact of the HR-PROFILE option */

5874:
5875: l_stmt_num := 30;
5876:
5877: /* The following line in the FROM clause of the select statement has been
5878: commented out because it will now be refering to cst_organization_definitions as an impact of the HR-PROFILE option */
5879:
5880: select set_of_books_id
5881: into l_rcv_sob_id
5882: /*from org_organization_definitions */

Line 5883: from cst_organization_definitions

5879:
5880: select set_of_books_id
5881: into l_rcv_sob_id
5882: /*from org_organization_definitions */
5883: from cst_organization_definitions
5884: where organization_id = i_to_org;
5885:
5886: l_stmt_num := 40;
5887:

Line 8493: FROM CST_ORGANIZATION_DEFINITIONS

8489: OPERATING_UNIT
8490: INTO l_pri_curr,
8491: l_set_of_books_id,
8492: l_ou_id
8493: FROM CST_ORGANIZATION_DEFINITIONS
8494: WHERE ORGANIZATION_ID = l_logical_org_id;
8495:
8496: --------------------------------------------------------------------
8497: -- Internal Order Issue to Expense could be to the same organization

Line 8526: FROM CST_ORGANIZATION_DEFINITIONS

8522: l_stmt_num := 80;
8523:
8524: SELECT CURRENCY_CODE
8525: INTO l_sending_curr
8526: FROM CST_ORGANIZATION_DEFINITIONS
8527: WHERE ORGANIZATION_ID = l_parent_org_id;
8528:
8529:
8530: -- Get the Conversion Type from the profile