DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 531: pay_element_entry_values_f eev1

527: pay_element_links_f el,
528: pay_element_types_f et,
529: pay_input_values_f iv1,
530: pay_element_entries_f ee,
531: pay_element_entry_values_f eev1
532: where asg1.assignment_id = p_assignment_id
533: and p_value_date between asg1.effective_start_date and asg1.effective_end_date
534: and p_value_date between asg2.effective_start_date and asg2.effective_end_date
535: and p_value_date between per.effective_start_date and per.effective_end_date

Line 1010: input_value pay_element_entry_values_f.screen_entry_value%type,

1006: benefit_expense_type varchar2 (200),
1007: benefit_expense_monetary_value number,
1008: benefit_exp_flag char (1), -- 'B' for Benefit and 'E' for expense
1009: input_value_name pay_input_values_f.name%type,
1010: input_value pay_element_entry_values_f.screen_entry_value%type,
1011: input_value_uom pay_input_values_f.uom%type
1012: );
1013:
1014: type benefit_expense_element_table is table of benefit_expense_element_rec

Line 1097: pay_element_entry_values_f eev1

1093: pay_element_links_f el,
1094: pay_element_types_f et,
1095: pay_input_values_f iv1,
1096: pay_element_entries_f ee,
1097: pay_element_entry_values_f eev1
1098: where asg1.assignment_id = p_assignment_id
1099: and p_value_date between asg1.effective_start_date and asg1.effective_end_date
1100: and p_value_date between asg2.effective_start_date and asg2.effective_end_date
1101: and p_value_date between per.effective_start_date and per.effective_end_date

Line 1130: pay_element_entry_values_f eev1

1126: pay_element_links_f el,
1127: pay_element_types_f et,
1128: pay_input_values_f iv1,
1129: pay_element_entries_f ee,
1130: pay_element_entry_values_f eev1
1131: where asg1.assignment_id = p_assignment_id
1132: and p_value_date between asg1.effective_start_date and asg1.effective_end_date
1133: and p_value_date between asg2.effective_start_date and asg2.effective_end_date
1134: and p_value_date between per.effective_start_date and per.effective_end_date