DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 49: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );

45: TYPE lock_rec IS RECORD ( archive_assact_id NUMBER);
46:
47: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_element_entry_values_f.SCREEN_ENTRY_VALUE%type );
48:
49: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );
50:
51:
52: TYPE tax_card_table IS TABLE OF tax_card_rec INDEX BY BINARY_INTEGER;
53: TYPE bal_val_table IS TABLE OF bal_val_rec INDEX BY BINARY_INTEGER;

Line 2521: ff_database_items d

2517:
2518: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
2519: SELECT u.creator_id
2520: FROM ff_user_entities u,
2521: ff_database_items d
2522: WHERE d.user_name = p_user_name
2523: AND u.user_entity_id = d.user_entity_id
2524: AND (u.legislation_code = 'NO' )
2525: AND (u.business_group_id IS NULL )

Line 4012: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );

4008: --------------
4009: /*
4010: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_input_values_f.NAME%type );
4011:
4012: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );
4013:
4014:
4015: TYPE tax_card_table IS TABLE OF tax_card_rec INDEX BY BINARY_INTEGER;
4016: