APPS.PAYWSDYG_PKG dependencies on FND_PRODUCT_INSTALLATIONS

Line 411: fnd_product_installations fpi,

407: -- Fetch the username from foundation (AOL) tables
408: CURSOR get_user(cp_appl IN VARCHAR2) IS
409: SELECT fou.oracle_username
410: FROM fnd_oracle_userid fou,
411: fnd_product_installations fpi,
412: fnd_application fa
413: WHERE fou.oracle_id = fpi.oracle_id
414: AND fpi.application_id = fa.application_id
415: AND fa.application_short_name = cp_appl;

Line 4399: fnd_product_installations prd,

4395: FROM dual
4396: WHERE EXISTS (
4397: SELECT 1
4398: FROM fnd_tables tab,
4399: fnd_product_installations prd,
4400: fnd_oracle_userid usr
4401: WHERE tab.table_name = p_table
4402: AND tab.application_id = prd.application_id
4403: AND (prd.application_id BETWEEN 800 AND 810

Line 4412: fnd_product_installations prd,

4408: --
4409: CURSOR csr_get_ownapp IS
4410: SELECT prd.application_id
4411: FROM fnd_tables tab,
4412: fnd_product_installations prd,
4413: fnd_oracle_userid usr
4414: WHERE tab.table_name = p_table
4415: AND tab.application_id = prd.application_id
4416: AND ((prd.application_id < 800 OR prd.application_id > 810)

Line 4458: fnd_product_installations prd,

4454: --
4455: CURSOR csr_get_owner IS
4456: SELECT usr.oracle_username
4457: FROM fnd_tables tab,
4458: fnd_product_installations prd,
4459: fnd_oracle_userid usr
4460: WHERE tab.table_name = p_table
4461: AND tab.application_id = prd.application_id
4462: AND (prd.application_id BETWEEN 800 AND 810

Line 4470: fnd_product_installations prd,

4466: CURSOR csr_get_ownex IS
4467: SELECT usr.oracle_username,
4468: prd.application_id
4469: FROM fnd_tables tab,
4470: fnd_product_installations prd,
4471: fnd_oracle_userid usr
4472: WHERE tab.table_name = p_table
4473: AND tab.application_id = prd.application_id
4474: AND ((prd.application_id < 800 OR prd.application_id > 810)