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_T4AEOY_ARCHIVE dependencies on FF_USER_ENTITIES

Line 354: from ff_user_entities UE,

350: /* Get the defined_balance_id for the specified balance DB item. */
351:
352: cursor csr_defined_balance is
353: select to_number(UE.creator_id)
354: from ff_user_entities UE,
355: ff_database_items DI
356: where DI.user_name = p_db_item_name
357: and UE.user_entity_id = DI.user_entity_id
358: and Ue.creator_type = 'B'

Line 1013: ff_user_entities fui

1009: || p_dbi_name);
1010: select fdi.user_entity_id
1011: into l_user_entity_id
1012: from ff_database_items fdi,
1013: ff_user_entities fui
1014: where user_name = p_dbi_name
1015: and fdi.user_entity_id = fui.user_entity_id
1016: and fui.legislation_code = 'CA';
1017:

Line 3262: l_province_uei ff_user_entities.user_entity_id%type;

3258: l_year_end date;
3259: l_context_no number := 60;
3260: l_count number := 0;
3261: l_jurisdiction varchar2(11);
3262: l_province_uei ff_user_entities.user_entity_id%type;
3263: l_county_uei ff_user_entities.user_entity_id%type;
3264: l_city_uei ff_user_entities.user_entity_id%type;
3265: l_county_sd_uei ff_user_entities.user_entity_id%type;
3266: l_city_sd_uei ff_user_entities.user_entity_id%type;

Line 3263: l_county_uei ff_user_entities.user_entity_id%type;

3259: l_context_no number := 60;
3260: l_count number := 0;
3261: l_jurisdiction varchar2(11);
3262: l_province_uei ff_user_entities.user_entity_id%type;
3263: l_county_uei ff_user_entities.user_entity_id%type;
3264: l_city_uei ff_user_entities.user_entity_id%type;
3265: l_county_sd_uei ff_user_entities.user_entity_id%type;
3266: l_city_sd_uei ff_user_entities.user_entity_id%type;
3267: l_province_abbrev pay_us_states.state_abbrev%type;

Line 3264: l_city_uei ff_user_entities.user_entity_id%type;

3260: l_count number := 0;
3261: l_jurisdiction varchar2(11);
3262: l_province_uei ff_user_entities.user_entity_id%type;
3263: l_county_uei ff_user_entities.user_entity_id%type;
3264: l_city_uei ff_user_entities.user_entity_id%type;
3265: l_county_sd_uei ff_user_entities.user_entity_id%type;
3266: l_city_sd_uei ff_user_entities.user_entity_id%type;
3267: l_province_abbrev pay_us_states.state_abbrev%type;
3268: l_county_name pay_us_counties.county_name%type;

Line 3265: l_county_sd_uei ff_user_entities.user_entity_id%type;

3261: l_jurisdiction varchar2(11);
3262: l_province_uei ff_user_entities.user_entity_id%type;
3263: l_county_uei ff_user_entities.user_entity_id%type;
3264: l_city_uei ff_user_entities.user_entity_id%type;
3265: l_county_sd_uei ff_user_entities.user_entity_id%type;
3266: l_city_sd_uei ff_user_entities.user_entity_id%type;
3267: l_province_abbrev pay_us_states.state_abbrev%type;
3268: l_county_name pay_us_counties.county_name%type;
3269: l_city_name pay_us_city_names.city_name%type;

Line 3266: l_city_sd_uei ff_user_entities.user_entity_id%type;

3262: l_province_uei ff_user_entities.user_entity_id%type;
3263: l_county_uei ff_user_entities.user_entity_id%type;
3264: l_city_uei ff_user_entities.user_entity_id%type;
3265: l_county_sd_uei ff_user_entities.user_entity_id%type;
3266: l_city_sd_uei ff_user_entities.user_entity_id%type;
3267: l_province_abbrev pay_us_states.state_abbrev%type;
3268: l_county_name pay_us_counties.county_name%type;
3269: l_city_name pay_us_city_names.city_name%type;
3270: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;