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.PAY_CA_GROUP_LEVEL_BAL_PKG dependencies on FF_CONTEXTS

Line 335: ff_contexts cxt

331: FROM per_all_assignments_f asg,
332: pay_payroll_actions pya,
333: pay_assignment_actions asa,
334: pay_action_contexts acx,
335: ff_contexts cxt
336: WHERE cxt.context_name = 'SOURCE_ID'
337: AND cxt.context_id = acx.context_id
338: AND acx.context_value = TO_CHAR(p_src_id)
339: AND asa.assignment_action_id = acx.assignment_action_id

Line 379: ff_contexts cxt

375: FROM per_all_assignments_f asg,
376: pay_payroll_actions pya,
377: pay_assignment_actions asa,
378: pay_action_contexts acx,
379: ff_contexts cxt
380: WHERE cxt.context_name = 'JURISDICTION_CODE'
381: AND cxt.context_id = acx.context_id
382: AND acx.context_value = p_jd
383: AND acx.assignment_action_id = asa.assignment_action_id

Line 418: ff_contexts cxt2,

414: FROM per_all_assignments_f asg,
415: pay_payroll_actions pya,
416: pay_assignment_actions asa,
417: pay_action_contexts acx2,
418: ff_contexts cxt2,
419: pay_action_contexts acx1,
420: ff_contexts cxt1
421: WHERE cxt1.context_name = 'SOURCE_ID'
422: AND cxt1.context_id = acx1.context_id

Line 420: ff_contexts cxt1

416: pay_assignment_actions asa,
417: pay_action_contexts acx2,
418: ff_contexts cxt2,
419: pay_action_contexts acx1,
420: ff_contexts cxt1
421: WHERE cxt1.context_name = 'SOURCE_ID'
422: AND cxt1.context_id = acx1.context_id
423: AND acx1.context_value = TO_CHAR(p_src_id)
424: AND cxt2.context_name = 'JURISDICTION_CODE'

Line 733: ff_contexts cxt2,

729: FROM per_all_assignments_f asg,
730: pay_payroll_actions pya,
731: pay_assignment_actions asa,
732: pay_action_contexts acx2,
733: ff_contexts cxt2,
734: pay_action_contexts acx1,
735: ff_contexts cxt1
736: WHERE cxt1.context_name = 'SOURCE_ID'
737: AND cxt1.context_id = acx1.context_id

Line 735: ff_contexts cxt1

731: pay_assignment_actions asa,
732: pay_action_contexts acx2,
733: ff_contexts cxt2,
734: pay_action_contexts acx1,
735: ff_contexts cxt1
736: WHERE cxt1.context_name = 'SOURCE_ID'
737: AND cxt1.context_id = acx1.context_id
738: AND acx1.context_value = TO_CHAR(p_src_id)
739: AND cxt2.context_name = 'JURISDICTION_CODE'

Line 981: ff_contexts cxt

977: p_start_date DATE,
978: p_end_date DATE) IS
979: SELECT DISTINCT(acx.assignment_id) assignment_id
980: FROM pay_action_contexts acx,
981: ff_contexts cxt
982: WHERE cxt.context_name = 'SOURCE_ID'
983: AND cxt.context_id = acx.context_id
984: AND acx.context_value = TO_CHAR(p_src_id)
985: AND EXISTS (SELECT 'X'

Line 1005: ff_contexts cxt

1001: p_start_date DATE,
1002: p_end_date DATE) IS
1003: SELECT DISTINCT(acx.assignment_id) assignment_id
1004: FROM pay_action_contexts acx,
1005: ff_contexts cxt
1006: WHERE cxt.context_name = 'JURISDICTION_CODE'
1007: AND cxt.context_id = acx.context_id
1008: AND acx.context_value = p_jd
1009: AND EXISTS (SELECT 'X'

Line 1025: ff_contexts cxt1,

1021: p_end_date DATE) IS
1022: SELECT DISTINCT(acx1.assignment_id) assignment_id
1023: FROM pay_action_contexts acx1,
1024: pay_action_contexts acx2,
1025: ff_contexts cxt1,
1026: ff_contexts cxt2
1027: WHERE cxt1.context_name = 'SOURCE_ID'
1028: AND cxt1.context_id = acx1.context_id
1029: AND acx1.context_value = TO_CHAR(p_src_id)

Line 1026: ff_contexts cxt2

1022: SELECT DISTINCT(acx1.assignment_id) assignment_id
1023: FROM pay_action_contexts acx1,
1024: pay_action_contexts acx2,
1025: ff_contexts cxt1,
1026: ff_contexts cxt2
1027: WHERE cxt1.context_name = 'SOURCE_ID'
1028: AND cxt1.context_id = acx1.context_id
1029: AND acx1.context_value = TO_CHAR(p_src_id)
1030: AND cxt2.context_name = 'JURISDICTION_CODE'

Line 1091: ff_contexts cxt

1087: p_end_date DATE) IS
1088: SELECT DISTINCT(acx.assignment_id) assignment_id
1089: FROM per_all_assignments_f asg,
1090: pay_action_contexts acx,
1091: ff_contexts cxt
1092: WHERE cxt.context_name = 'SOURCE_ID'
1093: AND cxt.context_id = acx.context_id
1094: AND acx.context_value = TO_CHAR(p_src_id)
1095: AND EXISTS (SELECT 'X'

Line 1136: ff_contexts cxt

1132: p_end_date DATE) IS
1133: SELECT DISTINCT(asg.assignment_id) assignment_id
1134: FROM per_all_assignments_f asg,
1135: pay_action_contexts acx,
1136: ff_contexts cxt
1137: WHERE cxt.context_name = 'JURISDICTION_CODE'
1138: AND cxt.context_id = acx.context_id
1139: AND acx.context_value = p_jd
1140: AND EXISTS (SELECT 'X'

Line 1177: ff_contexts cxt2,

1173: SELECT DISTINCT(acx1.assignment_id) assignment_id
1174: FROM per_all_assignments_f asg,
1175: pay_action_contexts acx2,
1176: pay_action_contexts acx1,
1177: ff_contexts cxt2,
1178: ff_contexts cxt1
1179: WHERE cxt1.context_name = 'SOURCE_ID'
1180: AND cxt1.context_id = acx1.context_id
1181: AND acx1.context_value = TO_CHAR(p_src_id)

Line 1178: ff_contexts cxt1

1174: FROM per_all_assignments_f asg,
1175: pay_action_contexts acx2,
1176: pay_action_contexts acx1,
1177: ff_contexts cxt2,
1178: ff_contexts cxt1
1179: WHERE cxt1.context_name = 'SOURCE_ID'
1180: AND cxt1.context_id = acx1.context_id
1181: AND acx1.context_value = TO_CHAR(p_src_id)
1182: AND acx1.assignment_id = asg.assignment_id

Line 1564: ff_contexts cxt1,

1560: p_end_date DATE) IS
1561: SELECT DISTINCT(acx1.assignment_id) assignment_id
1562: FROM pay_action_contexts acx1,
1563: pay_action_contexts acx2,
1564: ff_contexts cxt1,
1565: ff_contexts cxt2
1566: WHERE cxt1.context_name = 'SOURCE_ID'
1567: AND cxt1.context_id = acx1.context_id
1568: AND acx1.context_value = TO_CHAR(p_src_id)

Line 1565: ff_contexts cxt2

1561: SELECT DISTINCT(acx1.assignment_id) assignment_id
1562: FROM pay_action_contexts acx1,
1563: pay_action_contexts acx2,
1564: ff_contexts cxt1,
1565: ff_contexts cxt2
1566: WHERE cxt1.context_name = 'SOURCE_ID'
1567: AND cxt1.context_id = acx1.context_id
1568: AND acx1.context_value = TO_CHAR(p_src_id)
1569: AND cxt2.context_name = 'JURISDICTION_CODE'

Line 1718: ff_contexts cxt2,

1714: SELECT DISTINCT(acx1.assignment_id) assignment_id
1715: FROM per_all_assignments_f asg,
1716: pay_action_contexts acx2,
1717: pay_action_contexts acx1,
1718: ff_contexts cxt2,
1719: ff_contexts cxt1
1720: WHERE cxt1.context_name = 'SOURCE_ID'
1721: AND cxt1.context_id = acx1.context_id
1722: AND acx1.context_value = TO_CHAR(p_src_id)

Line 1719: ff_contexts cxt1

1715: FROM per_all_assignments_f asg,
1716: pay_action_contexts acx2,
1717: pay_action_contexts acx1,
1718: ff_contexts cxt2,
1719: ff_contexts cxt1
1720: WHERE cxt1.context_name = 'SOURCE_ID'
1721: AND cxt1.context_id = acx1.context_id
1722: AND acx1.context_value = TO_CHAR(p_src_id)
1723: AND acx1.assignment_id = asg.assignment_id

Line 2159: ff_contexts cxt

2155: FROM pay_payroll_actions pya,
2156: per_all_assignments_f asg,
2157: pay_assignment_actions asa,
2158: pay_action_contexts acx,
2159: ff_contexts cxt
2160: WHERE acx.context_value = TO_CHAR(p_src)
2161: AND cxt.context_id = acx.context_id
2162: AND cxt.context_name = 'SOURCE_ID'
2163: AND asa.assignment_action_id = acx.assignment_action_id