APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_INPUT_VALUES_F

Line 529: pay_input_values_f iv1,

525: per_all_assignments_f asg2,
526: per_all_people_f per,
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

Line 1009: input_value_name pay_input_values_f.name%type,

1005: type benefit_expense_element_rec is record (
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:

Line 1011: input_value_uom pay_input_values_f.uom%type

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
1015: index by binary_integer;

Line 1095: pay_input_values_f iv1,

1091: per_all_assignments_f asg2,
1092: per_all_people_f per,
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

Line 1128: pay_input_values_f iv1,

1124: per_all_assignments_f asg2,
1125: per_all_people_f per,
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