APPS.CSTPAVCP dependencies on CST_ORGANIZATION_DEFINITIONS

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

5662: END IF;
5663: l_stmt_num := 10;
5664:
5665: /* The following FROM clause in the select statement has been commented out
5666: because we now have to refer CST_ORGANIZATION_DEFINITIONS as a result of the
5667: impact of the HR-PROFILE option */
5668:
5669: select set_of_books_id
5670: into l_snd_sob_id

Line 5672: from cst_organization_definitions

5668:
5669: select set_of_books_id
5670: into l_snd_sob_id
5671: /*from org_organization_definitions */
5672: from cst_organization_definitions
5673: where organization_id = i_from_org;
5674:
5675: l_stmt_num := 20;
5676:

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

5681:
5682: l_stmt_num := 30;
5683:
5684: /* The following line in the FROM clause of the select statement has been
5685: commented out because it will now be refering to cst_organization_definitions as an impact of the HR-PROFILE option */
5686:
5687: select set_of_books_id
5688: into l_rcv_sob_id
5689: /*from org_organization_definitions */

Line 5690: from cst_organization_definitions

5686:
5687: select set_of_books_id
5688: into l_rcv_sob_id
5689: /*from org_organization_definitions */
5690: from cst_organization_definitions
5691: where organization_id = i_to_org;
5692:
5693: l_stmt_num := 40;
5694:

Line 8296: FROM CST_ORGANIZATION_DEFINITIONS

8292: OPERATING_UNIT
8293: INTO l_pri_curr,
8294: l_set_of_books_id,
8295: l_ou_id
8296: FROM CST_ORGANIZATION_DEFINITIONS
8297: WHERE ORGANIZATION_ID = l_logical_org_id;
8298:
8299: --------------------------------------------------------------------
8300: -- Internal Order Issue to Expense could be to the same organization

Line 8329: FROM CST_ORGANIZATION_DEFINITIONS

8325: l_stmt_num := 80;
8326:
8327: SELECT CURRENCY_CODE
8328: INTO l_sending_curr
8329: FROM CST_ORGANIZATION_DEFINITIONS
8330: WHERE ORGANIZATION_ID = l_parent_org_id;
8331:
8332:
8333: -- Get the Conversion Type from the profile