APPS.PAY_US_MMREF_LOCAL dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 359: FROM ff_archive_item_contexts con3,

355: /* cursor to check if the state tax Rules have been added or Not. */
356: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
357: IS
358: SELECT 'Y'
359: FROM ff_archive_item_contexts con3,
360: ff_archive_item_contexts con2,
361: ff_contexts fc3,
362: ff_contexts fc2,
363: ff_archive_items target,

Line 360: ff_archive_item_contexts con2,

356: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
357: IS
358: SELECT 'Y'
359: FROM ff_archive_item_contexts con3,
360: ff_archive_item_contexts con2,
361: ff_contexts fc3,
362: ff_contexts fc2,
363: ff_archive_items target,
364: ff_database_items fdi

Line 900: FROM ff_archive_item_contexts faic,

896: ELSIF p_report_type = 'STW2' THEN
897: p_sqlstr := '
898: SELECT DISTINCT
899: to_number(paa.serial_number)
900: FROM ff_archive_item_contexts faic,
901: ff_archive_items fai,
902: ff_database_items fdi,
903: pay_assignment_actions paa,
904: pay_payroll_actions ppa,

Line 998: ff_archive_item_contexts faic1, -- city_context

994: per_all_assignments_f paf,
995: pay_payroll_actions ppa1,
996: ff_contexts fc1 , --for city context
997: ff_archive_items fai1, -- city
998: ff_archive_item_contexts faic1, -- city_context
999: ff_database_items fdi1 --database_items for City_withheld
1000: --,pay_us_city_tax_info_f puctif
1001: WHERE
1002: ppa1.payroll_action_id = p_pactid

Line 1079: from ff_archive_item_contexts faic,

1075: FOR UPDATE OF paf.assignment_id;
1076: cursor csr_get_fed_wages(p_assignment_action_id number,
1077: p_tax_unit_id number) is
1078: select to_number(fai.value)
1079: from ff_archive_item_contexts faic,
1080: ff_archive_items fai,
1081: ff_contexts fc,
1082: ff_database_items fdi
1083: where fdi.user_name = 'A_GROSS_EARNINGS_PER_GRE_YTD'

Line 1299: ff_archive_item_contexts faic

1295: SELECT value
1296: INTO l_ein_val
1297: FROM ff_archive_items fai,
1298: ff_contexts fc,
1299: ff_archive_item_contexts faic
1300: WHERE fai.context1 = to_char(p_pactid)
1301: AND user_entity_id = c_id.user_entity_id
1302: AND faic.archive_item_id = fai.archive_item_id
1303: AND faic.context = to_char(l_gre)

Line 1348: ff_archive_item_contexts faic,

1344: CURSOR c_get_state_id
1345: IS
1346: SELECT value
1347: FROM ff_archive_items fai,
1348: ff_archive_item_contexts faic,
1349: ff_archive_item_contexts faic1
1350: WHERE context1 = to_char(p_pactid)
1351: AND user_entity_id = l_sit_state_id
1352: AND faic.archive_item_id = fai.archive_item_id

Line 1349: ff_archive_item_contexts faic1

1345: IS
1346: SELECT value
1347: FROM ff_archive_items fai,
1348: ff_archive_item_contexts faic,
1349: ff_archive_item_contexts faic1
1350: WHERE context1 = to_char(p_pactid)
1351: AND user_entity_id = l_sit_state_id
1352: AND faic.archive_item_id = fai.archive_item_id
1353: AND faic1.archive_item_id = fai.archive_item_id

Line 1447: ff_archive_item_contexts con3,

1443: cp_state_Code varchar2 )
1444: IS
1445: SELECT target.value
1446: FROM
1447: ff_archive_item_contexts con3,
1448: ff_archive_item_contexts con2,
1449: ff_contexts fc3,
1450: ff_contexts fc2,
1451: ff_archive_items target,

Line 1448: ff_archive_item_contexts con2,

1444: IS
1445: SELECT target.value
1446: FROM
1447: ff_archive_item_contexts con3,
1448: ff_archive_item_contexts con2,
1449: ff_contexts fc3,
1450: ff_contexts fc2,
1451: ff_archive_items target,
1452: ff_database_items fdi