APPS.PAY_US_MAGW2_REPORTING dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 366: FROM ff_archive_item_contexts faic1

362: AND fai.user_entity_id = cp_user_entity_id
363: AND fai.value > 0
364: AND EXISTS
365: ( SELECT 'Y'
366: FROM ff_archive_item_contexts faic1
367: WHERE faic1.archive_item_id = fai.archive_item_id
368: AND faic1.context_id = cp_context_tax_unit
369: AND rtrim(ltrim(faic1.context)) = cp_tax_unit_id
370: )

Line 373: FROM ff_archive_item_contexts faic2

369: AND rtrim(ltrim(faic1.context)) = cp_tax_unit_id
370: )
371: AND EXISTS
372: ( SELECT 'Y'
373: FROM ff_archive_item_contexts faic2
374: WHERE faic2.archive_item_id = fai.archive_item_id
375: AND faic2.context_id = cp_context_jursidiction
376: AND rtrim(ltrim(substr(faic2.context,1,2))) = p_state_code
377: );

Line 386: ff_archive_item_contexts con3,

382: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
383: IS
384: SELECT 'Y'
385: FROM
386: ff_archive_item_contexts con3,
387: ff_archive_item_contexts con2,
388: ff_contexts fc3,
389: ff_contexts fc2,
390: ff_archive_items target,

Line 387: ff_archive_item_contexts con2,

383: IS
384: SELECT 'Y'
385: FROM
386: ff_archive_item_contexts con3,
387: ff_archive_item_contexts con2,
388: ff_contexts fc3,
389: ff_contexts fc2,
390: ff_archive_items target,
391: ff_database_items fdi

Line 835: FROM ff_archive_item_contexts faic,

831: ELSIF p_report_type = 'STW2' THEN
832: p_sqlstr := '
833: SELECT DISTINCT
834: to_number(paa.serial_number)
835: FROM ff_archive_item_contexts faic,
836: ff_archive_items fai,
837: ff_database_items fdi,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa,

Line 922: FROM ff_archive_item_contexts faic,

918: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
919: 'A_W2_STATE_WAGES',
920: paa.tax_unit_id,
921: faic.context , 2),0)
922: FROM ff_archive_item_contexts faic,
923: ff_archive_items fai,
924: ff_database_items fdi,
925: pay_assignment_actions paa,
926: pay_payroll_actions ppa,

Line 1004: from ff_archive_item_contexts faic,

1000: FOR UPDATE OF paf.assignment_id;
1001: cursor csr_get_fed_wages(p_assignment_action_id number,
1002: p_tax_unit_id number) is
1003: select to_number(fai.value)
1004: from ff_archive_item_contexts faic,
1005: ff_archive_items fai,
1006: ff_contexts fc,
1007: ff_database_items fdi
1008: where fdi.user_name = 'A_GROSS_EARNINGS_PER_GRE_YTD'