APPS.PAY_MX_YREND_ARCH dependencies on FF_USER_ENTITIES

Line 235: ( user_entity_name ff_user_entities.user_entity_name%TYPE,

231: gv_package VARCHAR2(100);
232: gn_prev_asg_act_id NUMBER;
233: /* Bug 7529502*/
234: TYPE rec_entity_details IS RECORD
235: ( user_entity_name ff_user_entities.user_entity_name%TYPE,
236: def_bal_id ff_user_entities.creator_id%TYPE,
237: bal_value NUMBER);
238: TYPE entity_details_tab IS TABLE OF rec_entity_details INDEX BY BINARY_INTEGER;
239: g_archive_item_details entity_details_tab;

Line 236: def_bal_id ff_user_entities.creator_id%TYPE,

232: gn_prev_asg_act_id NUMBER;
233: /* Bug 7529502*/
234: TYPE rec_entity_details IS RECORD
235: ( user_entity_name ff_user_entities.user_entity_name%TYPE,
236: def_bal_id ff_user_entities.creator_id%TYPE,
237: bal_value NUMBER);
238: TYPE entity_details_tab IS TABLE OF rec_entity_details INDEX BY BINARY_INTEGER;
239: g_archive_item_details entity_details_tab;
240: g_ptu_bal_details entity_details_tab;

Line 273: ff_user_entities fue_live

269: pay_balance_attributes pba,
270: pay_defined_balances pdb_attr,
271: pay_defined_balances pdb_call,
272: pay_balance_dimensions pbd,
273: ff_user_entities fue_live
274: WHERE pbad.attribute_name = 'Year End Balances'
275: AND pbad.legislation_code = 'MX'
276: AND pba.attribute_id = pbad.attribute_id
277: AND pdb_attr.defined_balance_id = pba.defined_balance_id

Line 295: ff_user_entities fue_live

291: 0 tmp_bal_value
292: FROM pay_defined_balances pdb_call,
293: pay_balance_dimensions pbd,
294: pay_balance_types pbt,
295: ff_user_entities fue_live
296: WHERE pbt.balance_name IN ('ISR Withheld',
297: 'Year End ISR Subject for Profit Sharing',
298: 'Year End ISR Exempt for Profit Sharing')
299: AND pbt.balance_type_id = pdb_call.balance_type_id

Line 545: PROCEDURE create_archive_item(p_user_entity_name IN ff_user_entities.user_entity_name%TYPE

541: p_archive_action_id - current Assignment action ID.
542: ******************************************************************************/
543: /*Added for bug 7529502*/
544:
545: PROCEDURE create_archive_item(p_user_entity_name IN ff_user_entities.user_entity_name%TYPE
546: ,p_balance_value IN NUMBER
547: ,p_prev_archiver_exists IN VARCHAR2
548: ,p_tax_unit_id IN NUMBER
549: ,p_archive_action_id IN NUMBER)

Line 561: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;

557: ln_ovn NUMBER;
558: l_some_warning BOOLEAN;
559: ln_archive_item_id NUMBER;
560: ln_prev_isr_whld_value NUMBER;
561: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
562: lv_live_user_entity_name ff_user_entities.user_entity_name%TYPE;
563: ltab_entity_det entity_details_tab;
564: ln_count NUMBER;
565: ln_arc_item NUMBER;

Line 562: lv_live_user_entity_name ff_user_entities.user_entity_name%TYPE;

558: l_some_warning BOOLEAN;
559: ln_archive_item_id NUMBER;
560: ln_prev_isr_whld_value NUMBER;
561: lv_arch_user_entity_name ff_user_entities.user_entity_name%TYPE;
562: lv_live_user_entity_name ff_user_entities.user_entity_name%TYPE;
563: ltab_entity_det entity_details_tab;
564: ln_count NUMBER;
565: ln_arc_item NUMBER;
566:

Line 571: FROM ff_user_entities

567: -- Get archive DBI user entity ID
568: CURSOR c_get_arch_ue_id(cp_archive_item_name VARCHAR2)
569: IS
570: SELECT user_entity_id
571: FROM ff_user_entities
572: WHERE user_entity_name = cp_archive_item_name
573: AND creator_type = 'X'
574: AND creator_id = 0
575: AND legislation_code = 'MX';

Line 664: FROM ff_user_entities ffu, ff_archive_items ffa

660: --
661: CURSOR c_get_arch_val(cp_archive_item_name VARCHAR2)
662: IS
663: SELECT ffa.archive_item_id, ffa.value
664: FROM ff_user_entities ffu, ff_archive_items ffa
665: WHERE ffu.user_entity_name = cp_archive_item_name
666: AND ffu.creator_type = 'X'
667: AND ffu.creator_id = 0
668: AND ffu.legislation_code = 'MX'

Line 1946: FROM ff_user_entities

1942: CURSOR c_get_amends_amount IS
1943: SELECT nvl(fnd_number.canonical_to_number(value),0)
1944: FROM ff_archive_items
1945: WHERE user_entity_id = (SELECT user_entity_id
1946: FROM ff_user_entities
1947: WHERE user_entity_name = 'A_AMENDS_PER_PDS_GRE_YTD')
1948: AND context1 = p_archive_action_id;
1949:
1950: lv_ann_tax_calc_type VARCHAR2(240);