DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

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

43: balance_type_id NUMBER);
44:
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:

Line 3858: ,pay_element_entry_values_f eev1

3854: ,pay_element_links_f el
3855: ,pay_element_types_f et
3856: ,pay_input_values_f iv1
3857: ,pay_element_entries_f ee
3858: ,pay_element_entry_values_f eev1
3859: WHERE asg1.assignment_id = p_assignment_id
3860: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3861: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date
3862: AND per.person_id = asg1.person_id

Line 3886: ,pay_element_entry_values_f eev1

3882: ,pay_element_links_f el
3883: ,pay_element_types_f et
3884: ,pay_input_values_f iv1
3885: ,pay_element_entries_f ee
3886: ,pay_element_entry_values_f eev1
3887: WHERE asg1.assignment_id = p_assignment_id
3888: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3889: AND et.element_name = 'Tax'
3890: AND et.legislation_code = 'NO'

Line 4401: ,pay_element_entry_values_f eev1

4397: ,pay_element_links_f el
4398: ,pay_element_types_f et
4399: ,pay_input_values_f iv1
4400: ,pay_element_entries_f ee
4401: ,pay_element_entry_values_f eev1
4402: WHERE asg1.assignment_id = p_assignment_id
4403: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
4404: AND et.element_name = 'Tax Period Override Element'
4405: AND et.legislation_code = 'NO'