APPS.PY_ZA_TAX_CERTIFICATES dependencies on FF_DATABASE_ITEMS

Line 314: ff_database_items dbi

310:
311: select fnd_number.canonical_to_number(arc.value)
312: into l_site
313: from ff_archive_items arc,
314: ff_database_items dbi
315: where dbi.user_name = 'A_SITE_ASG_TAX_YTD'
316: and arc.user_entity_id = dbi.user_entity_id
317: and arc.context1 = p_assignment_action_id;
318:

Line 331: ff_database_items dbi

327:
328: select fnd_number.canonical_to_number(arc.value)
329: into l_paye
330: from ff_archive_items arc,
331: ff_database_items dbi
332: where dbi.user_name = 'A_PAYE_ASG_TAX_YTD'
333: and arc.user_entity_id = dbi.user_entity_id
334: and arc.context1 = p_assignment_action_id;
335:

Line 348: ff_database_items dbi

344:
345: select arc.value
346: into l_voluntary_tax
347: from ff_archive_items arc,
348: ff_database_items dbi
349: where dbi.user_name = 'A_VOLUNTARY_TAX_ASG_TAX_YTD'
350: and arc.user_entity_id = dbi.user_entity_id
351: and arc.context1 = p_assignment_action_id;
352:

Line 370: ff_database_items dbi

366:
367: select sum(arc.value)
368: into l_total
369: from ff_archive_items arc,
370: ff_database_items dbi
371: where dbi.user_name IN ('A_TAX_ON_LUMP_SUMS_ASG_LMPSM_TAX_YTD',
372: 'A_TAX_ON_RETIREMENT_FUND_LUMP_SUMS_ASG_LMPSM_TAX_YTD')
373: and arc.user_entity_id = dbi.user_entity_id
374: and arc.context1 = p_assignment_action_id;

Line 396: ff_database_items dbi

392: select sum(trunc(to_number(arc.value))) value
393: into l_sum
394: from -- pay_za_irp5_bal_codes irp5,
395: ff_archive_items arc,
396: ff_database_items dbi
397: where arc.context1 = p_assignment_action_id
398: and
399: (
400: arc.value is not null

Line 433: ff_database_items dbi

429: select sum(trunc(to_number(arc.value))) value
430: into l_lmpsm_sum
431: from -- pay_za_irp5_bal_codes irp5,
432: ff_archive_items arc,
433: ff_database_items dbi
434: where arc.context1 in (select ch.assignment_action_id
435: from pay_assignment_actions main
436: , pay_assignment_actions ch
437: where main.assignment_action_id = p_assignment_action_id

Line 497: ff_database_items dbi

493:
494: select sum(trunc(to_number(arc.value))) value
495: into l_sum
496: from ff_archive_items arc,
497: ff_database_items dbi
498: where arc.context1 = p_assignment_action_id
499: and dbi.user_name IN (
500: 'A_ANNUAL_PENSION_FUND_ASG_CLRNO_TAX_YTD'
501: ,'A_CURRENT_PENSION_FUND_ASG_CLRNO_TAX_YTD'

Line 544: ff_database_items dbi

540: select sum(trunc(to_number(arc.value))) value
541: into l_sum
542: from -- pay_za_irp5_bal_codes irp5,
543: ff_archive_items arc,
544: ff_database_items dbi
545: where arc.context1 = p_assignment_action_id
546: and
547: (
548: arc.value is not null