DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 27: 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 );

23: balance_type_id NUMBER);
24:
25: TYPE lock_rec IS RECORD ( archive_assact_id NUMBER);
26:
27: 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 );
28:
29: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );
30:
31:

Line 3105: ,pay_element_entry_values_f eev1

3101: ,pay_element_links_f el
3102: ,pay_element_types_f et
3103: ,pay_input_values_f iv1
3104: ,pay_element_entries_f ee
3105: ,pay_element_entry_values_f eev1
3106: WHERE asg1.assignment_id = p_assignment_id
3107: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3108: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date
3109: AND per.person_id = asg1.person_id

Line 3133: ,pay_element_entry_values_f eev1

3129: ,pay_element_links_f el
3130: ,pay_element_types_f et
3131: ,pay_input_values_f iv1
3132: ,pay_element_entries_f ee
3133: ,pay_element_entry_values_f eev1
3134: WHERE asg1.assignment_id = p_assignment_id
3135: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3136: AND et.element_name = 'Tax'
3137: AND et.legislation_code = 'DK'