APPS.PAY_US_MMREF_REPORTING_MT dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 316: FROM ff_archive_item_contexts con3,

312: /* cursor to check if the state tax Rules have been added or Not. */
313: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
314: IS
315: SELECT 'Y'
316: FROM ff_archive_item_contexts con3,
317: ff_archive_item_contexts con2,
318: ff_contexts fc3,
319: ff_contexts fc2,
320: ff_archive_items target,

Line 317: ff_archive_item_contexts con2,

313: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
314: IS
315: SELECT 'Y'
316: FROM ff_archive_item_contexts con3,
317: ff_archive_item_contexts con2,
318: ff_contexts fc3,
319: ff_contexts fc2,
320: ff_archive_items target,
321: ff_database_items fdi

Line 852: FROM ff_archive_item_contexts faic,

848: ELSIF p_report_type = 'STW2' THEN
849: p_sqlstr := '
850: SELECT DISTINCT
851: to_number(paa.serial_number)
852: FROM ff_archive_item_contexts faic,
853: ff_archive_items fai,
854: ff_database_items fdi,
855: pay_assignment_actions paa,
856: pay_payroll_actions ppa,

Line 940: FROM ff_archive_item_contexts faic,

936: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
937: 'A_W2_STATE_WAGES',
938: paa.tax_unit_id,
939: faic.context , 2),0)
940: FROM ff_archive_item_contexts faic,
941: ff_archive_items fai,
942: ff_database_items fdi,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa,

Line 1004: FROM ff_archive_item_contexts faic,

1000: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1001: 'A_W2_STATE_WAGES',
1002: paa.tax_unit_id,
1003: faic.context , 2),0)
1004: FROM ff_archive_item_contexts faic,
1005: ff_archive_items fai,
1006: ff_database_items fdi,
1007: pay_assignment_actions paa,
1008: pay_payroll_actions ppa,

Line 1083: from ff_archive_item_contexts faic,

1079: cursor csr_get_fed_wages(p_user_name varchar2,
1080: p_assignment_action_id number,
1081: p_tax_unit_id number) is
1082: select to_number(fai.value) value
1083: from ff_archive_item_contexts faic,
1084: ff_archive_items fai,
1085: ff_contexts fc,
1086: ff_database_items fdi
1087: where fdi.user_name = p_user_name

Line 1099: from ff_archive_item_contexts faic,

1095:
1096: cursor csr_get_fit_sub_wages(p_assignment_action_id number,
1097: p_tax_unit_id number) is
1098: select to_number(fai.value) value
1099: from ff_archive_item_contexts faic,
1100: ff_archive_items fai,
1101: ff_contexts fc,
1102: ff_database_items fdi
1103: where fdi.user_name IN ('A_REGULAR_EARNINGS_PER_GRE_YTD',

Line 1392: ff_archive_item_contexts faic

1388: SELECT value
1389: INTO l_ein_val
1390: FROM ff_archive_items fai,
1391: ff_contexts fc,
1392: ff_archive_item_contexts faic
1393: WHERE fai.context1 = to_char(p_pactid)
1394: AND user_entity_id = c_id.user_entity_id
1395: AND faic.archive_item_id = fai.archive_item_id
1396: AND faic.context = to_char(l_gre)

Line 1441: ff_archive_item_contexts faic,

1437: CURSOR c_get_state_id
1438: IS
1439: SELECT value
1440: FROM ff_archive_items fai,
1441: ff_archive_item_contexts faic,
1442: ff_archive_item_contexts faic1
1443: WHERE context1 = to_char(p_pactid)
1444: AND user_entity_id = l_sit_state_id
1445: AND faic.archive_item_id = fai.archive_item_id

Line 1442: ff_archive_item_contexts faic1

1438: IS
1439: SELECT value
1440: FROM ff_archive_items fai,
1441: ff_archive_item_contexts faic,
1442: ff_archive_item_contexts faic1
1443: WHERE context1 = to_char(p_pactid)
1444: AND user_entity_id = l_sit_state_id
1445: AND faic.archive_item_id = fai.archive_item_id
1446: AND faic1.archive_item_id = fai.archive_item_id

Line 1546: ff_archive_item_contexts con3,

1542: cp_state_Code varchar2 )
1543: IS
1544: SELECT target.value
1545: FROM
1546: ff_archive_item_contexts con3,
1547: ff_archive_item_contexts con2,
1548: ff_contexts fc3,
1549: ff_contexts fc2,
1550: ff_archive_items target,

Line 1547: ff_archive_item_contexts con2,

1543: IS
1544: SELECT target.value
1545: FROM
1546: ff_archive_item_contexts con3,
1547: ff_archive_item_contexts con2,
1548: ff_contexts fc3,
1549: ff_contexts fc2,
1550: ff_archive_items target,
1551: ff_database_items fdi