APPS.PY_ZA_TAX_CERTIFICATES dependencies on FF_DATABASE_ITEMS

Line 311: ff_database_items dbi

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;
315:

Line 328: ff_database_items dbi

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;
332:

Line 345: ff_database_items dbi

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;
349:

Line 367: ff_database_items dbi

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
371: and arc.context1 = p_assignment_action_id;

Line 393: ff_database_items dbi

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: (
397: arc.value is not null

Line 430: ff_database_items dbi

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
434: where main.assignment_action_id = p_assignment_action_id

Line 493: ff_database_items dbi

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'
497: ,'A_CURRENT_PENSION_FUND_ASG_CLRNO_TAX_YTD'

Line 538: ff_database_items dbi

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: (
542: arc.value is not null