APPS.PAY_US_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 377: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

373: and UE.user_entity_id = DI.user_entity_id
374: and Ue.creator_type = 'B'
375: and UE.legislation_code = 'US';
376:
377: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
378:
379: BEGIN
380: --hr_utility.trace('p_db_item_name is '||p_db_item_name);
381:

Line 571: pay_defined_balances pdb,

567:
568: /* cursor c_get_puerto_rico_bal is
569: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
570: from ff_user_entities fue,
571: pay_defined_balances pdb,
572: pay_balance_dimensions pbd,
573: pay_balance_types pbt
574: where pbt.balance_name in (
575: 'Territory Pension Annuity',

Line 766: pay_defined_balances pdb,

762:
763: /* cursor c_get_1099r_bal is
764: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
765: from ff_user_entities fue,
766: pay_defined_balances pdb,
767: pay_balance_dimensions pbd,
768: pay_balance_types pbt
769: where pbt.balance_name in (
770: 'Capital Gain',

Line 994: pay_defined_balances pdb,

990: cp_balance_dimension in varchar2,
991: cp_business_group_id in number ) is
992: select pdb.defined_balance_id,fue.user_entity_name
993: from ff_user_entities fue,
994: pay_defined_balances pdb,
995: pay_balance_dimensions pbd,
996: pay_balance_types pbt
997: where pbt.balance_name = cp_balance_name
998: and pbd.database_item_suffix= cp_balance_dimension