38: -- latest balance
39: --
40: assactid pay_assignment_latest_balances.assignment_action_id%type,
41: value pay_assignment_latest_balances.value%type,
42: actseq pay_assignment_actions.action_sequence%type,
43: effdate date,
44: --
45: -- previous latest balance
46: --
45: -- previous latest balance
46: --
47: -- prv_assactid pay_assignment_latest_balances.prev_assignment_action_id%type,
48: -- prv_value pay_assignment_latest_balances.prev_balance_value%type,
49: -- prv_actseq pay_assignment_actions.action_sequence%type,
50: -- prv_effdate date,
51: --
52: -- expired balance
53: --
52: -- expired balance
53: --
54: exp_assactid pay_assignment_latest_balances.expired_assignment_action_id%type,
55: exp_value pay_assignment_latest_balances.expired_value%type,
56: exp_actseq pay_assignment_actions.action_sequence%type,
57: exp_effdate date
58: );
59:
60: -----------------------------
72: type ListValue is table of
73: pay_assignment_latest_balances.value%type
74: index by binary_integer;
75: type ListActSeq is table of
76: pay_assignment_actions.action_sequence%type
77: index by binary_integer;
78: type ListEffDate is table of
79: date
80: index by binary_integer;
84: type ListExpValue is table of
85: pay_assignment_latest_balances.expired_value%type
86: index by binary_integer;
87: type ListExpActSeq is table of
88: pay_assignment_actions.action_sequence%type
89: index by binary_integer;
90: type ListExpEffDate is table of
91: date
92: index by binary_integer;