eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_W2_DBITEMS dependencies on FF_CONTEXTS

Line 199: from ff_contexts

195: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
196: --
197: select context_id
198: into l_tax_unit_context_id
199: from ff_contexts
200: where context_name = 'TAX_UNIT_ID';
201:
202: --++ l_text :=
203: --++ 'hr_tax_units_v target

Line 304: --++ from ff_contexts

300:
301:
302: --++ select context_id
303: --++ into l_jurisdiction_code_context_id
304: --++ from ff_contexts
305: --++ where context_name = 'JURISDICTION_CODE';
306:
307:
308: --++ insert_route

Line 329: from ff_contexts

325: --++ 'Y');
326:
327: select context_id
328: into l_context1
329: from ff_contexts
330: where context_name = 'PAYROLL_ACTION_ID';
331:
332: select context_id
333: into l_context2

Line 334: from ff_contexts

330: where context_name = 'PAYROLL_ACTION_ID';
331:
332: select context_id
333: into l_context2
334: from ff_contexts
335: where context_name = 'TAX_UNIT_ID';
336:
337: insert_route
338: ('SEH_SQWL_NUM_EMPS_US',

Line 387: from ff_contexts

383:
384: -- find the context_ids
385: select context_id
386: into l_tax_unit_context_id
387: from ff_contexts
388: where context_name = 'TAX_UNIT_ID';
389:
390: select context_id
391: into l_assignment_action_context_id

Line 392: from ff_contexts

388: where context_name = 'TAX_UNIT_ID';
389:
390: select context_id
391: into l_assignment_action_context_id
392: from ff_contexts
393: where context_name = 'ASSIGNMENT_ACTION_ID';
394:
395: select context_id
396: into l_payroll_action_context_id

Line 397: from ff_contexts

393: where context_name = 'ASSIGNMENT_ACTION_ID';
394:
395: select context_id
396: into l_payroll_action_context_id
397: from ff_contexts
398: where context_name = 'PAYROLL_ACTION_ID';
399:
400: /* For EOY */
401: select context_id

Line 403: from ff_contexts

399:
400: /* For EOY */
401: select context_id
402: into l_jurisdiction_context_id
403: from ff_contexts
404: where context_name = 'JURISDICTION_CODE';
405:
406: BEGIN
407:

Line 413: ff_contexts fc2,

409:
410: -- define the employer archive route
411: l_text :=
412: 'ff_archive_item_contexts con2,
413: ff_contexts fc2,
414: ff_archive_items target
415: where target.user_entity_id = &U1
416: and target.context1 = to_char(&B1)
417: /* context of payroll action id */

Line 538: ff_contexts fc2,

534:
535: -- define the employer archive route
536: l_text :=
537: 'ff_archive_item_contexts con2,
538: ff_contexts fc2,
539: ff_archive_items target
540: where target.user_entity_id = &U1
541: and target.context1 = to_char(&B1)
542: /* context of payroll action id */

Line 647: ff_contexts fc2,

643:
644: -- define the employer archive route
645: l_text :=
646: 'ff_archive_item_contexts con2,
647: ff_contexts fc2,
648: ff_archive_items target
649: where target.user_entity_id = &U1
650: and target.context1 = to_char(&B1)
651: /* context of payroll action id */

Line 768: ff_contexts fc2,

764: hr_utility.trace('setting route text for EMPLOYER_TAX_UNIT_ARCHIVE_DATE');
765:
766: l_text :=
767: 'ff_archive_item_contexts con2,
768: ff_contexts fc2,
769: ff_archive_items target
770: where target.context1 = &B1
771: /* context of payroll_action_id */
772: and target.user_entity_id = &U1

Line 891: ff_contexts fc2,

887: hr_utility.trace('setting route text for EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER');
888:
889: l_text :=
890: 'ff_archive_item_contexts con2,
891: ff_contexts fc2,
892: ff_archive_items target
893: where target.context1 = &B1
894: /* context of payroll_action_id */
895: and target.user_entity_id = &U1

Line 1022: ff_contexts fc2,

1018: hr_utility.trace('setting route text for EMPLOYER_TAX_UNIT_ARCHIVE');
1019:
1020: l_text :=
1021: 'ff_archive_item_contexts con2,
1022: ff_contexts fc2,
1023: ff_archive_items target
1024: where target.context1 = &B1
1025: /* context of payroll_action_id */
1026: and target.user_entity_id = &U1

Line 1149: ff_contexts fc3,

1145:
1146: l_text :=
1147: 'ff_archive_item_contexts con3,
1148: ff_archive_item_contexts con2,
1149: ff_contexts fc3,
1150: ff_contexts fc2,
1151: ff_archive_items target
1152: where target.context1 = &B1
1153: /* context of payroll_action_id */

Line 1150: ff_contexts fc2,

1146: l_text :=
1147: 'ff_archive_item_contexts con3,
1148: ff_archive_item_contexts con2,
1149: ff_contexts fc3,
1150: ff_contexts fc2,
1151: ff_archive_items target
1152: where target.context1 = &B1
1153: /* context of payroll_action_id */
1154: and target.user_entity_id = &U1

Line 1289: ff_contexts fc3,

1285:
1286: l_text :=
1287: 'ff_archive_item_contexts con3,
1288: ff_archive_item_contexts con2,
1289: ff_contexts fc3,
1290: ff_contexts fc2,
1291: ff_archive_items target
1292: where target.context1 = &B1
1293: /* context of payroll_action_id */

Line 1290: ff_contexts fc2,

1286: l_text :=
1287: 'ff_archive_item_contexts con3,
1288: ff_archive_item_contexts con2,
1289: ff_contexts fc3,
1290: ff_contexts fc2,
1291: ff_archive_items target
1292: where target.context1 = &B1
1293: /* context of payroll_action_id */
1294: and target.user_entity_id = &U1

Line 1429: ff_contexts fc3,

1425:
1426: l_text :=
1427: 'ff_archive_item_contexts con3,
1428: ff_archive_item_contexts con2,
1429: ff_contexts fc3,
1430: ff_contexts fc2,
1431: ff_archive_items target
1432: where target.context1 = &B1
1433: /* context of payroll_action_id */

Line 1430: ff_contexts fc2,

1426: l_text :=
1427: 'ff_archive_item_contexts con3,
1428: ff_archive_item_contexts con2,
1429: ff_contexts fc3,
1430: ff_contexts fc2,
1431: ff_archive_items target
1432: where target.context1 = &B1
1433: /* context of payroll_action_id */
1434: and target.user_entity_id = &U1

Line 1763: ff_contexts fc2,

1759: contexts. */
1760:
1761: l_text :=
1762: 'ff_archive_item_contexts con2,
1763: ff_contexts fc2,
1764: ff_archive_items target
1765: where target.user_entity_id = &U1
1766: and target.context1 = to_char(&B1)
1767: /* context assignment action id */

Line 1849: ff_contexts fc2,

1845: contexts. */
1846:
1847: l_text :=
1848: 'ff_archive_item_contexts con2,
1849: ff_contexts fc2,
1850: ff_archive_items target
1851: where target.user_entity_id = &U1
1852: and target.context1 = to_char(&B1)
1853: /* context assignment action id */

Line 1934: ff_contexts fc3,

1930:
1931: l_text :=
1932: 'ff_archive_item_contexts con3,
1933: ff_archive_item_contexts con2,
1934: ff_contexts fc3,
1935: ff_contexts fc2,
1936: ff_archive_items target
1937: where target.user_entity_id = &U1
1938: and target.context1 = to_char(&B1)

Line 1935: ff_contexts fc2,

1931: l_text :=
1932: 'ff_archive_item_contexts con3,
1933: ff_archive_item_contexts con2,
1934: ff_contexts fc3,
1935: ff_contexts fc2,
1936: ff_archive_items target
1937: where target.user_entity_id = &U1
1938: and target.context1 = to_char(&B1)
1939: /* context assignment action id */

Line 2034: ff_contexts fc3,

2030:
2031: l_text :=
2032: 'ff_archive_item_contexts con3,
2033: ff_archive_item_contexts con2,
2034: ff_contexts fc3,
2035: ff_contexts fc2,
2036: ff_archive_items target
2037: where target.user_entity_id = &U1
2038: and target.context1 = to_char(&B1)

Line 2035: ff_contexts fc2,

2031: l_text :=
2032: 'ff_archive_item_contexts con3,
2033: ff_archive_item_contexts con2,
2034: ff_contexts fc3,
2035: ff_contexts fc2,
2036: ff_archive_items target
2037: where target.user_entity_id = &U1
2038: and target.context1 = to_char(&B1)
2039: /* context assignment action id */

Line 2133: ff_contexts fc3,

2129:
2130: l_text :=
2131: 'ff_archive_item_contexts con3,
2132: ff_archive_item_contexts con2,
2133: ff_contexts fc3,
2134: ff_contexts fc2,
2135: ff_archive_items target
2136: where target.user_entity_id = &U1
2137: and target.context1 = to_char(&B1)

Line 2134: ff_contexts fc2,

2130: l_text :=
2131: 'ff_archive_item_contexts con3,
2132: ff_archive_item_contexts con2,
2133: ff_contexts fc3,
2134: ff_contexts fc2,
2135: ff_archive_items target
2136: where target.user_entity_id = &U1
2137: and target.context1 = to_char(&B1)
2138: /* context assignment action id */

Line 2232: ff_contexts fc3,

2228:
2229: l_text :=
2230: 'ff_archive_item_contexts con3,
2231: ff_archive_item_contexts con2,
2232: ff_contexts fc3,
2233: ff_contexts fc2,
2234: ff_archive_items target
2235: where target.user_entity_id = &U1
2236: and target.context1 = to_char(&B1)

Line 2233: ff_contexts fc2,

2229: l_text :=
2230: 'ff_archive_item_contexts con3,
2231: ff_archive_item_contexts con2,
2232: ff_contexts fc3,
2233: ff_contexts fc2,
2234: ff_archive_items target
2235: where target.user_entity_id = &U1
2236: and target.context1 = to_char(&B1)
2237: /* context assignment action id */

Line 2373: ff_contexts c

2369: -- and ue.business_group_id is null;
2370: end; -- ]
2371: --
2372: select count(1) into l_asg_count from ff_route_context_usages rc,
2373: ff_contexts c
2374: where rc.context_id = c.context_id
2375: and rc.route_id = l_live_route_id
2376: and context_name like 'ASSIGNMENT%';
2377:

Line 2577: ff_contexts c

2573: select c.context_name,
2574: rc.context_id,
2575: rc.sequence_no
2576: from ff_route_context_usages rc,
2577: ff_contexts c
2578: where rc.context_id = c.context_id
2579: and rc.route_id= l_live_route_id
2580: order by 3;
2581: