APPS.PY_ZA_TAX_CERTIFICATES dependencies on FF_ARCHIVE_ITEMS

Line 310: from ff_archive_items arc,

306: begin
307:
308: select fnd_number.canonical_to_number(arc.value)
309: into l_site
310: from ff_archive_items arc,
311: ff_database_items dbi
312: where dbi.user_name = 'A_SITE_ASG_TAX_YTD'
313: and arc.user_entity_id = dbi.user_entity_id
314: and arc.context1 = p_assignment_action_id;

Line 327: from ff_archive_items arc,

323: begin
324:
325: select fnd_number.canonical_to_number(arc.value)
326: into l_paye
327: from ff_archive_items arc,
328: ff_database_items dbi
329: where dbi.user_name = 'A_PAYE_ASG_TAX_YTD'
330: and arc.user_entity_id = dbi.user_entity_id
331: and arc.context1 = p_assignment_action_id;

Line 344: from ff_archive_items arc,

340: begin
341:
342: select arc.value
343: into l_voluntary_tax
344: from ff_archive_items arc,
345: ff_database_items dbi
346: where dbi.user_name = 'A_VOLUNTARY_TAX_ASG_TAX_YTD'
347: and arc.user_entity_id = dbi.user_entity_id
348: and arc.context1 = p_assignment_action_id;

Line 366: from ff_archive_items arc,

362: begin
363:
364: select sum(arc.value)
365: into l_total
366: from ff_archive_items arc,
367: ff_database_items dbi
368: where dbi.user_name IN ('A_TAX_ON_LUMP_SUMS_ASG_LMPSM_TAX_YTD',
369: 'A_TAX_ON_RETIREMENT_FUND_LUMP_SUMS_ASG_LMPSM_TAX_YTD')
370: and arc.user_entity_id = dbi.user_entity_id

Line 392: ff_archive_items arc,

388: -- Added for the balance feed enhancement
389: select sum(trunc(to_number(arc.value))) value
390: into l_sum
391: from -- pay_za_irp5_bal_codes irp5,
392: ff_archive_items arc,
393: ff_database_items dbi
394: where arc.context1 = p_assignment_action_id
395: and
396: (

Line 429: ff_archive_items arc,

425: -- Check the Lump Sum Certificate Income Sources
426: select sum(trunc(to_number(arc.value))) value
427: into l_lmpsm_sum
428: from -- pay_za_irp5_bal_codes irp5,
429: ff_archive_items arc,
430: ff_database_items dbi
431: where arc.context1 in (select ch.assignment_action_id
432: from pay_assignment_actions main
433: , pay_assignment_actions ch

Line 492: from ff_archive_items arc,

488: begin
489:
490: select sum(trunc(to_number(arc.value))) value
491: into l_sum
492: from ff_archive_items arc,
493: ff_database_items dbi
494: where arc.context1 = p_assignment_action_id
495: and dbi.user_name IN (
496: 'A_ANNUAL_PENSION_FUND_ASG_CLRNO_TAX_YTD'

Line 537: ff_archive_items arc,

533: -- Check the Lump Sum Certificate Income Sources
534: select sum(trunc(to_number(arc.value))) value
535: into l_sum
536: from -- pay_za_irp5_bal_codes irp5,
537: ff_archive_items arc,
538: ff_database_items dbi
539: where arc.context1 = p_assignment_action_id
540: and
541: (