APPS.PAY_CA_DBI_ROE dependencies on PAY_REPORT_FORMAT_ITEMS_F

Line 452: l_archive_type pay_report_format_items_f.archive_type%TYPE;

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

Line 453: l_updatable_flag pay_report_format_items_f.updatable_flag%TYPE;

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

Line 464: from pay_report_format_items_f

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

Line 524: update pay_report_format_items_f

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

Line 543: insert into pay_report_format_items_f

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