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 4361: fnd_product_installations prd,

4357: FROM dual
4358: WHERE EXISTS (
4359: SELECT 1
4360: FROM fnd_tables tab,
4361: fnd_product_installations prd,
4362: fnd_oracle_userid usr
4363: WHERE tab.table_name = p_table
4364: AND tab.application_id = prd.application_id
4365: AND (prd.application_id BETWEEN 800 AND 810

Line 4374: fnd_product_installations prd,

4370: --
4371: CURSOR csr_get_ownapp IS
4372: SELECT prd.application_id
4373: FROM fnd_tables tab,
4374: fnd_product_installations prd,
4375: fnd_oracle_userid usr
4376: WHERE tab.table_name = p_table
4377: AND tab.application_id = prd.application_id
4378: AND ((prd.application_id < 800 OR prd.application_id > 810)

Line 4420: fnd_product_installations prd,

4416: --
4417: CURSOR csr_get_owner IS
4418: SELECT usr.oracle_username
4419: FROM fnd_tables tab,
4420: fnd_product_installations prd,
4421: fnd_oracle_userid usr
4422: WHERE tab.table_name = p_table
4423: AND tab.application_id = prd.application_id
4424: AND (prd.application_id BETWEEN 800 AND 810

Line 4432: fnd_product_installations prd,

4428: CURSOR csr_get_ownex IS
4429: SELECT usr.oracle_username,
4430: prd.application_id
4431: FROM fnd_tables tab,
4432: fnd_product_installations prd,
4433: fnd_oracle_userid usr
4434: WHERE tab.table_name = p_table
4435: AND tab.application_id = prd.application_id
4436: AND ((prd.application_id < 800 OR prd.application_id > 810)