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 2663: ,pay_element_entry_values_f eev1

2659: ,pay_element_links_f el
2660: ,pay_element_types_f et
2661: ,pay_input_values_f iv1
2662: ,pay_element_entries_f ee
2663: ,pay_element_entry_values_f eev1
2664: WHERE asg1.assignment_id = p_assignment_id
2665: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
2666: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date
2667: AND per.person_id = asg1.person_id

Line 2691: ,pay_element_entry_values_f eev1

2687: ,pay_element_links_f el
2688: ,pay_element_types_f et
2689: ,pay_input_values_f iv1
2690: ,pay_element_entries_f ee
2691: ,pay_element_entry_values_f eev1
2692: WHERE asg1.assignment_id = p_assignment_id
2693: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
2694: AND et.element_name = 'Tax'
2695: AND et.legislation_code = 'DK'