APPS.PAY_MX_YREND_ARCH dependencies on FF_USER_ENTITIES

Line 399: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;

395: ln_ovn NUMBER;
396: l_some_warning BOOLEAN;
397: ln_archive_item_id NUMBER;
398: ln_prev_isr_whld_value NUMBER;
399: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
400: lv_live_user_entity_name ff_user_entities.user_entity_name%TYPE;
401: ln_arc_item NUMBER;
402:
403: -- Get balances for archival

Line 400: lv_live_user_entity_name ff_user_entities.user_entity_name%TYPE;

396: l_some_warning BOOLEAN;
397: ln_archive_item_id NUMBER;
398: ln_prev_isr_whld_value NUMBER;
399: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
400: lv_live_user_entity_name ff_user_entities.user_entity_name%TYPE;
401: ln_arc_item NUMBER;
402:
403: -- Get balances for archival
404: CURSOR c_get_balances IS

Line 414: ff_user_entities fue_live

410: pay_balance_attributes pba,
411: pay_defined_balances pdb_attr,
412: pay_defined_balances pdb_call,
413: pay_balance_dimensions pbd,
414: ff_user_entities fue_live
415: WHERE pbad.attribute_name = 'Year End Balances'
416: AND pbad.legislation_code = 'MX'
417: AND pba.attribute_id = pbad.attribute_id
418: AND pdb_attr.defined_balance_id = pba.defined_balance_id

Line 436: ff_user_entities fue_live

432: p_ytd_action_id)
433: FROM pay_defined_balances pdb_call,
434: pay_balance_dimensions pbd,
435: pay_balance_types pbt,
436: ff_user_entities fue_live
437: WHERE pbt.balance_name IN ('ISR Withheld',
438: 'Year End ISR Subject for Profit Sharing',
439: 'Year End ISR Exempt for Profit Sharing')
440: AND pbt.balance_type_id = pdb_call.balance_type_id

Line 453: FROM ff_user_entities

449: -- Get archive DBI user entity ID
450: CURSOR c_get_arch_ue_id(cp_archive_item_name VARCHAR2)
451: IS
452: SELECT user_entity_id
453: FROM ff_user_entities
454: WHERE user_entity_name = cp_archive_item_name
455: AND creator_type = 'X'
456: AND creator_id = 0
457: AND legislation_code = 'MX';