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

3865: ,pay_element_links_f el
3866: ,pay_element_types_f et
3867: ,pay_input_values_f iv1
3868: ,pay_element_entries_f ee
3869: ,pay_element_entry_values_f eev1
3870: WHERE asg1.assignment_id = p_assignment_id
3871: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3872: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date
3873: AND per.person_id = asg1.person_id

Line 3897: ,pay_element_entry_values_f eev1

3893: ,pay_element_links_f el
3894: ,pay_element_types_f et
3895: ,pay_input_values_f iv1
3896: ,pay_element_entries_f ee
3897: ,pay_element_entry_values_f eev1
3898: WHERE asg1.assignment_id = p_assignment_id
3899: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3900: AND et.element_name = 'Tax'
3901: AND et.legislation_code = 'NO'

Line 4412: ,pay_element_entry_values_f eev1

4408: ,pay_element_links_f el
4409: ,pay_element_types_f et
4410: ,pay_input_values_f iv1
4411: ,pay_element_entries_f ee
4412: ,pay_element_entry_values_f eev1
4413: WHERE asg1.assignment_id = p_assignment_id
4414: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
4415: AND et.element_name = 'Tax Period Override Element'
4416: AND et.legislation_code = 'NO'