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_US_SQWL_UDF dependencies on FF_ARCHIVE_ITEMS

Line 476: FROM ff_archive_items arch

472:
473:
474: CURSOR c_get_archived_emp_code (p_user_entity_id NUMBER) IS
475: SELECT arch.value
476: FROM ff_archive_items arch
477: WHERE arch.user_entity_id = p_user_entity_id
478: AND arch.context1 = p_assignment_action_id;
479:
480: BEGIN

Line 906: ff_archive_items target,ff_user_entities fue

902:
903: CURSOR c_get_location_id IS
904: select fnd_number.canonical_to_number(target.value)
905: from
906: ff_archive_items target,ff_user_entities fue
907: where target.user_entity_id = fue.user_entity_id
908: and fue.user_entity_name='A_SQWL_LOC_QTR_END'
909: and target.context1 = to_char(p_assignment_action_id);
910:

Line 983: l_ar_out_of_state_code ff_archive_items.value%TYPE;

979:
980: FUNCTION get_ar_out_of_state_code (p_assignment_action_id number)
981: RETURN varchar2 IS
982:
983: l_ar_out_of_state_code ff_archive_items.value%TYPE;
984: l_user_entity_id ff_database_items.user_entity_id%TYPE;
985:
986: CURSOR get_user_entity_id (p_dbi_name IN VARCHAR2)
987: IS

Line 996: FROM ff_archive_items target

992: CURSOR get_archive_data (p_assignment_action_id IN NUMBER,
993: p_user_entity_id IN NUMBER)
994: IS
995: SELECT NVL(target.value, ' ')
996: FROM ff_archive_items target
997: WHERE target.user_entity_id = p_user_entity_id
998: AND target.context1 = p_assignment_action_id;
999:
1000: BEGIN

Line 1081: ff_archive_items fai,

1077: select sum(to_number(nvl(fai.value, '0')) - to_number(nvl(fai1.value, '0')))
1078: into lv_employer_total_wages
1079: from pay_payroll_actions ppa,
1080: pay_assignment_actions paa,
1081: ff_archive_items fai,
1082: ff_archive_items fai1,
1083: ff_database_items fdi,
1084: ff_database_items fdi1
1085: where ppa.payroll_action_id = p_payroll_action_id

Line 1082: ff_archive_items fai1,

1078: into lv_employer_total_wages
1079: from pay_payroll_actions ppa,
1080: pay_assignment_actions paa,
1081: ff_archive_items fai,
1082: ff_archive_items fai1,
1083: ff_database_items fdi,
1084: ff_database_items fdi1
1085: where ppa.payroll_action_id = p_payroll_action_id
1086: and ppa.payroll_action_id = paa.payroll_action_id

Line 1132: ff_archive_items fai,

1128: select sum(to_number(nvl(fai.value, '0')) - to_number(nvl(fai1.value, '0')) - to_number(nvl(fai2.value, '0')))
1129: into lv_excess_wages
1130: from pay_payroll_actions ppa,
1131: pay_assignment_actions paa,
1132: ff_archive_items fai,
1133: ff_archive_items fai1,
1134: ff_archive_items fai2,
1135: ff_database_items fdi,
1136: ff_database_items fdi1,

Line 1133: ff_archive_items fai1,

1129: into lv_excess_wages
1130: from pay_payroll_actions ppa,
1131: pay_assignment_actions paa,
1132: ff_archive_items fai,
1133: ff_archive_items fai1,
1134: ff_archive_items fai2,
1135: ff_database_items fdi,
1136: ff_database_items fdi1,
1137: ff_database_items fdi2

Line 1134: ff_archive_items fai2,

1130: from pay_payroll_actions ppa,
1131: pay_assignment_actions paa,
1132: ff_archive_items fai,
1133: ff_archive_items fai1,
1134: ff_archive_items fai2,
1135: ff_database_items fdi,
1136: ff_database_items fdi1,
1137: ff_database_items fdi2
1138: where ppa.payroll_action_id = p_payroll_action_id

Line 1181: ff_archive_items fai,

1177: p_sui_taxable,
1178: p_sui_gross
1179: from pay_payroll_actions ppa,
1180: pay_assignment_actions paa,
1181: ff_archive_items fai,
1182: ff_archive_items fai1,
1183: ff_archive_items fai2,
1184: ff_archive_items fai3,
1185: ff_database_items fdi,

Line 1182: ff_archive_items fai1,

1178: p_sui_gross
1179: from pay_payroll_actions ppa,
1180: pay_assignment_actions paa,
1181: ff_archive_items fai,
1182: ff_archive_items fai1,
1183: ff_archive_items fai2,
1184: ff_archive_items fai3,
1185: ff_database_items fdi,
1186: ff_database_items fdi1,

Line 1183: ff_archive_items fai2,

1179: from pay_payroll_actions ppa,
1180: pay_assignment_actions paa,
1181: ff_archive_items fai,
1182: ff_archive_items fai1,
1183: ff_archive_items fai2,
1184: ff_archive_items fai3,
1185: ff_database_items fdi,
1186: ff_database_items fdi1,
1187: ff_database_items fdi2,

Line 1184: ff_archive_items fai3,

1180: pay_assignment_actions paa,
1181: ff_archive_items fai,
1182: ff_archive_items fai1,
1183: ff_archive_items fai2,
1184: ff_archive_items fai3,
1185: ff_database_items fdi,
1186: ff_database_items fdi1,
1187: ff_database_items fdi2,
1188: ff_database_items fdi3

Line 1240: ff_archive_items fai,

1236: c_tax_unit_id number) is /* It will fetch required Person level DBIs*/
1237: select paa.assignment_action_id paa_id, fdi.user_name dbi_name, nvl(fai.value, '0') value
1238: from pay_payroll_actions ppa,
1239: pay_assignment_actions paa,
1240: ff_archive_items fai,
1241: ff_database_items fdi
1242: where ppa.payroll_action_id = c_payroll_action_id --1436067
1243: and ppa.payroll_action_id = paa.payroll_action_id
1244: and paa.tax_unit_id = c_tax_unit_id --7896