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

Line 289: ff_user_entities join.

285: per_all_assignments_f instead of
286: per_assignmentes_f.
287: New items archived for Employer.
288: Legislation code checks for
289: ff_user_entities join.
290: Specific archiving for Puerto Rico.
291:
292: 03-Aug-2000 ssarma 40.43 EOY 2000: Changes to city, county cursors
293: Checks for formula compilation.

Line 402: from ff_user_entities UE,

398: /* Get the defined_balance_id for the specified balance DB item. */
399:
400: cursor csr_defined_balance is
401: select to_number(UE.creator_id)
402: from ff_user_entities UE,
403: ff_database_items DI
404: where DI.user_name = p_db_item_name
405: and UE.user_entity_id = DI.user_entity_id
406: and Ue.creator_type = 'B'

Line 587: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;

583: l_step number;
584: ln_count number := 0;
585: lv_balance_name VARCHAR2(80) := '';
586: lv_balance_dimension VARCHAR2(80) := '';
587: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
588: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
589: ln_arch_user_entity_id NUMBER;
590: ln_defined_balance_id number := 0;
591: ln_user_entity_id number := 0;

Line 588: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;

584: ln_count number := 0;
585: lv_balance_name VARCHAR2(80) := '';
586: lv_balance_dimension VARCHAR2(80) := '';
587: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
588: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
589: ln_arch_user_entity_id NUMBER;
590: ln_defined_balance_id number := 0;
591: ln_user_entity_id number := 0;
592:

Line 602: from ff_user_entities fue,

598: and org_information_context = 'W2 Reporting Rules';
599:
600: /* cursor c_get_puerto_rico_bal is
601: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
602: from ff_user_entities fue,
603: pay_defined_balances pdb,
604: pay_balance_dimensions pbd,
605: pay_balance_types pbt
606: where pbt.balance_name in (

Line 631: from ff_user_entities fue

627: */
628:
629: cursor c_get_arch_user_entity (cp_live_database_item in varchar2) is
630: select fue.user_entity_id
631: from ff_user_entities fue
632: where fue.user_entity_name = cp_live_database_item
633: and ((fue.legislation_code = 'US' and
634: fue.business_group_id is null)
635: or (fue.legislation_code is null and

Line 768: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;

764: l_step number;
765: ln_count number := 0;
766: lv_balance_name VARCHAR2(500) := '';
767: lv_balance_dimension VARCHAR2(80) := '';
768: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
769: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
770: ln_arch_user_entity_id NUMBER;
771: ln_defined_balance_id number := 0;
772: ln_user_entity_id number := 0;

Line 769: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;

765: ln_count number := 0;
766: lv_balance_name VARCHAR2(500) := '';
767: lv_balance_dimension VARCHAR2(80) := '';
768: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
769: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
770: ln_arch_user_entity_id NUMBER;
771: ln_defined_balance_id number := 0;
772: ln_user_entity_id number := 0;
773: lv_1099r_flag varchar2(5) := null;

Line 801: from ff_user_entities fue,

797: );
798:
799: /* cursor c_get_1099r_bal is
800: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
801: from ff_user_entities fue,
802: pay_defined_balances pdb,
803: pay_balance_dimensions pbd,
804: pay_balance_types pbt
805: where pbt.balance_name in (

Line 829: from ff_user_entities fue

825: */
826:
827: cursor c_get_arch_user_entity (cp_live_database_item in varchar2) is
828: select fue.user_entity_id
829: from ff_user_entities fue
830: where fue.user_entity_name = cp_live_database_item
831: and ((fue.legislation_code = 'US' and
832: fue.business_group_id is null)
833: or (fue.legislation_code is null and

Line 1010: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;

1006: ln_count number := 0;
1007: psd_count number := 0;--For the Bug 13724610
1008: lv_balance_name VARCHAR2(80) := '';
1009: lv_balance_dimension VARCHAR2(80) := '';
1010: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
1011: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
1012: ln_arch_user_entity_id NUMBER;
1013: ln_defined_balance_id number := 0;
1014: ln_user_entity_id number := 0;

Line 1011: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;

1007: psd_count number := 0;--For the Bug 13724610
1008: lv_balance_name VARCHAR2(80) := '';
1009: lv_balance_dimension VARCHAR2(80) := '';
1010: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
1011: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
1012: ln_arch_user_entity_id NUMBER;
1013: ln_defined_balance_id number := 0;
1014: ln_user_entity_id number := 0;
1015:

Line 1038: from ff_user_entities fue,

1034: cp_balance_name in varchar2,
1035: cp_balance_dimension in varchar2,
1036: cp_business_group_id in number ) is
1037: select pdb.defined_balance_id,fue.user_entity_name
1038: from ff_user_entities fue,
1039: pay_defined_balances pdb,
1040: pay_balance_dimensions pbd,
1041: pay_balance_types pbt
1042: where pbt.balance_name = cp_balance_name

Line 1059: from ff_user_entities fue

1055: pbd.business_group_id = cp_business_group_id)) ;
1056: */
1057: cursor c_get_arch_user_entity (cp_live_database_item in varchar2) is
1058: select fue.user_entity_id
1059: from ff_user_entities fue
1060: where fue.user_entity_name = cp_live_database_item
1061: and ((fue.legislation_code = 'US' and
1062: fue.business_group_id is null)
1063: or (fue.legislation_code is null and

Line 1167: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;

1163: ln_count number := 0;
1164: psd_count number := 0;
1165: lv_balance_name VARCHAR2(80) := '';
1166: lv_balance_dimension VARCHAR2(80) := '';
1167: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
1168: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
1169: ln_arch_user_entity_id NUMBER;
1170: ln_defined_balance_id number := 0;
1171: ln_user_entity_id number := 0;

Line 1168: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;

1164: psd_count number := 0;
1165: lv_balance_name VARCHAR2(80) := '';
1166: lv_balance_dimension VARCHAR2(80) := '';
1167: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
1168: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
1169: ln_arch_user_entity_id NUMBER;
1170: ln_defined_balance_id number := 0;
1171: ln_user_entity_id number := 0;
1172:

Line 1175: from ff_user_entities fue

1171: ln_user_entity_id number := 0;
1172:
1173: cursor c_get_arch_user_entity (cp_live_database_item in varchar2) is
1174: select fue.user_entity_id
1175: from ff_user_entities fue
1176: where fue.user_entity_name = cp_live_database_item
1177: and ((fue.legislation_code = 'US' and
1178: fue.business_group_id is null)
1179: or (fue.legislation_code is null and

Line 1306: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;

1302: l_step number;
1303: ln_count number := 0;
1304: lv_balance_name VARCHAR2(80) := '';
1305: lv_balance_dimension VARCHAR2(80) := '';
1306: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
1307: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
1308: ln_arch_user_entity_id NUMBER;
1309: ln_defined_balance_id number := 0;
1310: ln_user_entity_id number := 0;

Line 1307: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;

1303: ln_count number := 0;
1304: lv_balance_name VARCHAR2(80) := '';
1305: lv_balance_dimension VARCHAR2(80) := '';
1306: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
1307: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
1308: ln_arch_user_entity_id NUMBER;
1309: ln_defined_balance_id number := 0;
1310: ln_user_entity_id number := 0;
1311:

Line 1325: from ff_user_entities fue

1321: and ATTRIBUTE1='CP';--Archive only lookup code created through Concurrent program;
1322:
1323: cursor c_get_arch_user_entity (cp_live_database_item in varchar2) is
1324: select fue.user_entity_id
1325: from ff_user_entities fue
1326: where fue.user_entity_name = cp_live_database_item
1327: and ((fue.legislation_code = 'US' and
1328: fue.business_group_id is null)
1329: or (fue.legislation_code is null and

Line 1812: ff_user_entities fue

1808:
1809: select fdi.user_entity_id
1810: into l_user_entity_id
1811: from ff_database_items fdi,
1812: ff_user_entities fue
1813: where fdi.user_name = p_dbi_name
1814: and fue.user_entity_id = fdi.user_entity_id
1815: and fue.legislation_code = 'US';
1816:

Line 3422: ff_user_entities fue

3418:
3419: CURSOR c_get_ff_arch IS
3420: select fai.archive_item_id
3421: from ff_archive_items fai,
3422: ff_user_entities fue
3423: where context1 =p_context
3424: and fai.user_entity_id = fue.user_entity_id
3425: and user_entity_name = p_archive_name ;
3426:

Line 3556: l_state_uei ff_user_entities.user_entity_id%type;

3552: l_year_end date;
3553: l_context_no number := 60;
3554: l_count number := 0;
3555: l_jurisdiction varchar2(11);
3556: l_state_uei ff_user_entities.user_entity_id%type;
3557: l_county_uei ff_user_entities.user_entity_id%type;
3558: l_city_uei ff_user_entities.user_entity_id%type;
3559: l_county_sd_uei ff_user_entities.user_entity_id%type;
3560: l_city_sd_uei ff_user_entities.user_entity_id%type;

Line 3557: l_county_uei ff_user_entities.user_entity_id%type;

3553: l_context_no number := 60;
3554: l_count number := 0;
3555: l_jurisdiction varchar2(11);
3556: l_state_uei ff_user_entities.user_entity_id%type;
3557: l_county_uei ff_user_entities.user_entity_id%type;
3558: l_city_uei ff_user_entities.user_entity_id%type;
3559: l_county_sd_uei ff_user_entities.user_entity_id%type;
3560: l_city_sd_uei ff_user_entities.user_entity_id%type;
3561: l_state_abbrev pay_us_states.state_abbrev%type;

Line 3558: l_city_uei ff_user_entities.user_entity_id%type;

3554: l_count number := 0;
3555: l_jurisdiction varchar2(11);
3556: l_state_uei ff_user_entities.user_entity_id%type;
3557: l_county_uei ff_user_entities.user_entity_id%type;
3558: l_city_uei ff_user_entities.user_entity_id%type;
3559: l_county_sd_uei ff_user_entities.user_entity_id%type;
3560: l_city_sd_uei ff_user_entities.user_entity_id%type;
3561: l_state_abbrev pay_us_states.state_abbrev%type;
3562: l_county_name pay_us_counties.county_name%type;

Line 3559: l_county_sd_uei ff_user_entities.user_entity_id%type;

3555: l_jurisdiction varchar2(11);
3556: l_state_uei ff_user_entities.user_entity_id%type;
3557: l_county_uei ff_user_entities.user_entity_id%type;
3558: l_city_uei ff_user_entities.user_entity_id%type;
3559: l_county_sd_uei ff_user_entities.user_entity_id%type;
3560: l_city_sd_uei ff_user_entities.user_entity_id%type;
3561: l_state_abbrev pay_us_states.state_abbrev%type;
3562: l_county_name pay_us_counties.county_name%type;
3563: l_city_name pay_us_city_names.city_name%type;

Line 3560: l_city_sd_uei ff_user_entities.user_entity_id%type;

3556: l_state_uei ff_user_entities.user_entity_id%type;
3557: l_county_uei ff_user_entities.user_entity_id%type;
3558: l_city_uei ff_user_entities.user_entity_id%type;
3559: l_county_sd_uei ff_user_entities.user_entity_id%type;
3560: l_city_sd_uei ff_user_entities.user_entity_id%type;
3561: l_state_abbrev pay_us_states.state_abbrev%type;
3562: l_county_name pay_us_counties.county_name%type;
3563: l_city_name pay_us_city_names.city_name%type;
3564: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;

Line 3615: l_psd_user_entity_id ff_user_entities.user_entity_id%type;

3611: -- for the Bug#13724610
3612: l_psd_jurisdiction varchar2(16);
3613: l_psd_balance_value number;
3614: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
3615: l_psd_user_entity_id ff_user_entities.user_entity_id%type;
3616: lv_user_entity_name ff_user_entities.user_entity_name%type;
3617: ln_business_group_id number;
3618: lv_balance_name pay_balance_types.balance_name%type;
3619: ln_psd_def_bal_id pay_defined_balances.defined_balance_id%type;

Line 3616: lv_user_entity_name ff_user_entities.user_entity_name%type;

3612: l_psd_jurisdiction varchar2(16);
3613: l_psd_balance_value number;
3614: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
3615: l_psd_user_entity_id ff_user_entities.user_entity_id%type;
3616: lv_user_entity_name ff_user_entities.user_entity_name%type;
3617: ln_business_group_id number;
3618: lv_balance_name pay_balance_types.balance_name%type;
3619: ln_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
3620: ln_bal_value number;