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 = cp_name;
454: --
455: l_appl VARCHAR2(50);

Line 4252: FROM fnd_tables tab

4248: SELECT 1
4249: FROM dual
4250: WHERE EXISTS (
4251: SELECT 1
4252: FROM fnd_tables tab
4253: WHERE tab.table_name = p_table
4254: AND (tab.application_id BETWEEN 800 AND 810
4255: OR tab.application_id IN (8301,453,8302,8303,8403,203))
4256: );

Line 4260: FROM fnd_tables

4256: );
4257: --
4258: CURSOR csr_get_tabapp IS
4259: SELECT application_id
4260: FROM fnd_tables
4261: WHERE table_name = p_table
4262: AND ((application_id < 800 OR application_id > 810)
4263: AND application_id NOT IN (8301,453,8302,8303,8403,203));
4264: --

Line 4303: FROM fnd_columns col,fnd_tables tab

4299: SELECT 1
4300: FROM dual
4301: WHERE EXISTS (
4302: SELECT 1
4303: FROM fnd_columns col,fnd_tables tab
4304: WHERE tab.table_name = p_table
4305: AND col.table_id = tab.table_id
4306: AND col.application_id = tab.application_id
4307: AND col.column_name = p_column

Line 4314: FROM fnd_columns col,fnd_tables tab

4310: );
4311: --
4312: CURSOR csr_get_colapp IS
4313: SELECT tab.application_id
4314: FROM fnd_columns col,fnd_tables tab
4315: WHERE tab.table_name = p_table
4316: AND col.table_id = tab.table_id
4317: AND col.application_id = tab.application_id
4318: AND ((tab.application_id < 800 OR tab.application_id > 810)

Line 4360: FROM fnd_tables tab,

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

Line 4373: FROM fnd_tables tab,

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

Line 4419: FROM fnd_tables tab,

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

Line 4431: FROM fnd_tables tab,

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