eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on FF_USER_ENTITIES

Line 380: from ff_user_entities UE,

376: /* Get the defined_balance_id for the specified balance DB item. */
377:
378: cursor csr_defined_balance is
379: select to_number(UE.creator_id)
380: from ff_user_entities UE,
381: ff_database_items DI
382: where DI.user_name = p_db_item_name
383: and UE.user_entity_id = DI.user_entity_id
384: and Ue.creator_type = 'B';

Line 2808: l_province_uei ff_user_entities.user_entity_id%type;

2804: l_year_end date;
2805: l_context_no number := 60;
2806: l_count number := 0;
2807: l_jurisdiction varchar2(11);
2808: l_province_uei ff_user_entities.user_entity_id%type;
2809: l_county_uei ff_user_entities.user_entity_id%type;
2810: l_city_uei ff_user_entities.user_entity_id%type;
2811: l_county_sd_uei ff_user_entities.user_entity_id%type;
2812: l_city_sd_uei ff_user_entities.user_entity_id%type;

Line 2809: l_county_uei ff_user_entities.user_entity_id%type;

2805: l_context_no number := 60;
2806: l_count number := 0;
2807: l_jurisdiction varchar2(11);
2808: l_province_uei ff_user_entities.user_entity_id%type;
2809: l_county_uei ff_user_entities.user_entity_id%type;
2810: l_city_uei ff_user_entities.user_entity_id%type;
2811: l_county_sd_uei ff_user_entities.user_entity_id%type;
2812: l_city_sd_uei ff_user_entities.user_entity_id%type;
2813: l_province_abbrev pay_us_states.state_abbrev%type;

Line 2810: l_city_uei ff_user_entities.user_entity_id%type;

2806: l_count number := 0;
2807: l_jurisdiction varchar2(11);
2808: l_province_uei ff_user_entities.user_entity_id%type;
2809: l_county_uei ff_user_entities.user_entity_id%type;
2810: l_city_uei ff_user_entities.user_entity_id%type;
2811: l_county_sd_uei ff_user_entities.user_entity_id%type;
2812: l_city_sd_uei ff_user_entities.user_entity_id%type;
2813: l_province_abbrev pay_us_states.state_abbrev%type;
2814: l_county_name pay_us_counties.county_name%type;

Line 2811: l_county_sd_uei ff_user_entities.user_entity_id%type;

2807: l_jurisdiction varchar2(11);
2808: l_province_uei ff_user_entities.user_entity_id%type;
2809: l_county_uei ff_user_entities.user_entity_id%type;
2810: l_city_uei ff_user_entities.user_entity_id%type;
2811: l_county_sd_uei ff_user_entities.user_entity_id%type;
2812: l_city_sd_uei ff_user_entities.user_entity_id%type;
2813: l_province_abbrev pay_us_states.state_abbrev%type;
2814: l_county_name pay_us_counties.county_name%type;
2815: l_city_name pay_us_city_names.city_name%type;

Line 2812: l_city_sd_uei ff_user_entities.user_entity_id%type;

2808: l_province_uei ff_user_entities.user_entity_id%type;
2809: l_county_uei ff_user_entities.user_entity_id%type;
2810: l_city_uei ff_user_entities.user_entity_id%type;
2811: l_county_sd_uei ff_user_entities.user_entity_id%type;
2812: l_city_sd_uei ff_user_entities.user_entity_id%type;
2813: l_province_abbrev pay_us_states.state_abbrev%type;
2814: l_county_name pay_us_counties.county_name%type;
2815: l_city_name pay_us_city_names.city_name%type;
2816: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;