APPS.PAYWSDYG_PKG dependencies on FND_TABLES

Line 451: fnd_tables ft

447: -- Get the application short name from the foundation tables
448: CURSOR get_table(cp_name IN VARCHAR2) IS
449: SELECT fa.application_short_name
450: FROM fnd_application fa,
451: fnd_tables ft
452: WHERE fa.application_id = ft.application_id
453: AND ft.table_name like translate(cp_name,'#','%');
454: --
455: l_appl VARCHAR2(50);

Line 4290: FROM fnd_tables tab

4286: SELECT 1
4287: FROM dual
4288: WHERE EXISTS (
4289: SELECT 1
4290: FROM fnd_tables tab
4291: WHERE tab.table_name = p_table
4292: AND (tab.application_id BETWEEN 800 AND 810
4293: OR tab.application_id IN (8301,453,8302,8303,8403,203))
4294: );

Line 4298: FROM fnd_tables

4294: );
4295: --
4296: CURSOR csr_get_tabapp IS
4297: SELECT application_id
4298: FROM fnd_tables
4299: WHERE table_name = p_table
4300: AND ((application_id < 800 OR application_id > 810)
4301: AND application_id NOT IN (8301,453,8302,8303,8403,203));
4302: --

Line 4341: FROM fnd_columns col,fnd_tables tab

4337: SELECT 1
4338: FROM dual
4339: WHERE EXISTS (
4340: SELECT 1
4341: FROM fnd_columns col,fnd_tables tab
4342: WHERE tab.table_name = p_table
4343: AND col.table_id = tab.table_id
4344: AND col.application_id = tab.application_id
4345: AND col.column_name = p_column

Line 4352: FROM fnd_columns col,fnd_tables tab

4348: );
4349: --
4350: CURSOR csr_get_colapp IS
4351: SELECT tab.application_id
4352: FROM fnd_columns col,fnd_tables tab
4353: WHERE tab.table_name = p_table
4354: AND col.table_id = tab.table_id
4355: AND col.application_id = tab.application_id
4356: AND ((tab.application_id < 800 OR tab.application_id > 810)

Line 4398: FROM fnd_tables tab,

4394: SELECT 1
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

Line 4411: FROM fnd_tables tab,

4407: );
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

Line 4457: FROM fnd_tables tab,

4453: l_app NUMBER(15);
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

Line 4469: FROM fnd_tables tab,

4465: --
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