DBA Data[Home] [Help]

APPS.PAY_CA_BALANCE_VIEW_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 42: actseq pay_assignment_actions.action_sequence%type,

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: --

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

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: --

Line 56: exp_actseq pay_assignment_actions.action_sequence%type,

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: -----------------------------

Line 76: pay_assignment_actions.action_sequence%type

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;

Line 88: pay_assignment_actions.action_sequence%type

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;