APPS.PAY_FI_ARCHIVE_MTRA dependencies on FF_DATABASE_ITEMS

Line 211: l_subsidy_for_low_paid_bal ff_database_items.user_name%type;

207: l_tax_card_type_code varchar2 (50);
208: l_subsidy_for_low_paid_emp number ;
209: l_subsidy_witholding_tax_ded number := 0;
210: l_subsidy_tax_at_source_dec number := 0;
211: l_subsidy_for_low_paid_bal ff_database_items.user_name%type;
212:
213:
214:
215:

Line 367: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)

363: AND a.pmeth_information_category ='FI Third Party Payment';
364:
365: rg_account_number csr_account_number%rowtype;
366:
367: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
368: IS
369: SELECT ue.creator_id
370: FROM ff_user_entities ue,
371: ff_database_items di

Line 371: ff_database_items di

367: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
368: IS
369: SELECT ue.creator_id
370: FROM ff_user_entities ue,
371: ff_database_items di
372: WHERE di.user_name = csr_v_Balance_Name
373: AND ue.user_entity_id = di.user_entity_id
374: AND ue.legislation_code = 'FI'
375: AND ue.business_group_id is NULL