APPS.PAY_CA_DBI_ROE dependencies on PAY_REPORT_FORMAT_ITEMS_F

Line 454: l_archive_type pay_report_format_items_f.archive_type%TYPE;

450: end_of_time constant date := to_date('4712/12/31','YYYY/MM/DD');
451:
452: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
453: l_report_type pay_report_format_mappings_f.report_type%TYPE;
454: l_archive_type pay_report_format_items_f.archive_type%TYPE;
455: l_updatable_flag pay_report_format_items_f.updatable_flag%TYPE;
456:
457: cursor cur_format_item is
458: select fue.user_entity_id

Line 455: l_updatable_flag pay_report_format_items_f.updatable_flag%TYPE;

451:
452: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
453: l_report_type pay_report_format_mappings_f.report_type%TYPE;
454: l_archive_type pay_report_format_items_f.archive_type%TYPE;
455: l_updatable_flag pay_report_format_items_f.updatable_flag%TYPE;
456:
457: cursor cur_format_item is
458: select fue.user_entity_id
459: from ff_user_entities fue

Line 466: from pay_report_format_items_f

462: ret number := 0;
463:
464: cursor cur_format_items_exists is
465: select 'x'
466: from pay_report_format_items_f
467: where report_type = 'ROE' and
468: report_qualifier = 'ROEQ' and
469: report_category = 'ROEC' and
470: user_entity_id = l_user_entity_id and

Line 526: update pay_report_format_items_f

522: if cur_format_items_exists%found then
523:
524: close cur_format_items_exists;
525:
526: update pay_report_format_items_f
527: set updatable_flag = l_updatable_flag,
528: archive_type = l_archive_type,
529: display_sequence = p_display_sequence
530: where

Line 545: insert into pay_report_format_items_f

541: else
542:
543: close cur_format_items_exists;
544:
545: insert into pay_report_format_items_f
546: (
547: report_type,
548: report_qualifier,
549: report_category,