DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 48: actseq pay_assignment_actions.action_sequence%type,

44: -- latest balance
45: --
46: assactid pay_assignment_latest_balances.assignment_action_id%type,
47: value pay_assignment_latest_balances.value%type,
48: actseq pay_assignment_actions.action_sequence%type,
49: effdate date,
50: --
51: -- previous latest balance
52: --

Line 55: -- prv_actseq pay_assignment_actions.action_sequence%type,

51: -- previous latest balance
52: --
53: -- prv_assactid pay_assignment_latest_balances.prev_assignment_action_id%type,
54: -- prv_value pay_assignment_latest_balances.prev_balance_value%type,
55: -- prv_actseq pay_assignment_actions.action_sequence%type,
56: -- prv_effdate date,
57: --
58: -- expired balance
59: --

Line 62: exp_actseq pay_assignment_actions.action_sequence%type,

58: -- expired balance
59: --
60: exp_assactid pay_assignment_latest_balances.expired_assignment_action_id%type,
61: exp_value pay_assignment_latest_balances.expired_value%type,
62: exp_actseq pay_assignment_actions.action_sequence%type,
63: exp_effdate date
64: );
65:
66: -----------------------------

Line 82: pay_assignment_actions.action_sequence%type

78: type ListValue is table of
79: pay_assignment_latest_balances.value%type
80: index by binary_integer;
81: type ListActSeq is table of
82: pay_assignment_actions.action_sequence%type
83: index by binary_integer;
84: type ListEffDate is table of
85: date
86: index by binary_integer;

Line 94: pay_assignment_actions.action_sequence%type

90: type ListExpValue is table of
91: pay_assignment_latest_balances.expired_value%type
92: index by binary_integer;
93: type ListExpActSeq is table of
94: pay_assignment_actions.action_sequence%type
95: index by binary_integer;
96: type ListExpEffDate is table of
97: date
98: index by binary_integer;