APPS.PAY_US_PSD_XML dependencies on FF_USER_ENTITIES

Line 108: ff_user_entities UE

104: -- Get the defined_balance_id for the specified balance DB item.
105: CURSOR csr_defined_balance IS
106: SELECT TO_NUMBER(UE.creator_id)
107: FROM ff_database_items DI,
108: ff_user_entities UE
109: WHERE DI.user_name = p_db_item_name
110: AND UE.user_entity_id = DI.user_entity_id
111: AND UE.creator_type = 'B'
112: AND UE.legislation_code = 'US';

Line 2731: from ff_user_entities

2727: '_PER_JD_GRE_MONTH');
2728:
2729: select USER_ENTITY_NAME
2730: into pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name
2731: from ff_user_entities
2732: where creator_id= (pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id)
2733: and CREATOR_TYPE='B';
2734:
2735: ELSIF (instr(lv_balance_name, 'QTD') <> 0) THEN

Line 2744: from ff_user_entities

2740: substr(lv_balance_name, 1 , (instr(lv_balance_name, 'QTD')-2)),
2741: '_PER_JD_GRE_QTD');
2742: select USER_ENTITY_NAME
2743: into pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name
2744: from ff_user_entities
2745: where creator_id= (pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id)
2746: and CREATOR_TYPE='B';
2747: END IF;
2748: