DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 42: lat_balid pay_assignment_latest_balances.latest_balance_id%type,

38: type LatBal is record
39: (
40: -- latest_balance_id
41: --
42: lat_balid pay_assignment_latest_balances.latest_balance_id%type,
43: --
44: -- latest balance
45: --
46: assactid pay_assignment_latest_balances.assignment_action_id%type,

Line 46: assactid pay_assignment_latest_balances.assignment_action_id%type,

42: lat_balid pay_assignment_latest_balances.latest_balance_id%type,
43: --
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: --

Line 47: value pay_assignment_latest_balances.value%type,

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

Line 53: -- prv_assactid pay_assignment_latest_balances.prev_assignment_action_id%type,

49: effdate date,
50: --
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: --

Line 54: -- prv_value pay_assignment_latest_balances.prev_balance_value%type,

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

Line 60: exp_assactid pay_assignment_latest_balances.expired_assignment_action_id%type,

56: -- prv_effdate date,
57: --
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: );

Line 61: exp_value pay_assignment_latest_balances.expired_value%type,

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

Line 73: pay_assignment_latest_balances.latest_balance_id%type

69: -- BHOMAN - can't PLSQL tables of records, so replace LatBalList
70: -- with individual tables for each element
71: -- type LatBalList is table of LatBal index by binary_integer;
72: type ListLatBalId is table of
73: pay_assignment_latest_balances.latest_balance_id%type
74: index by binary_integer;
75: type ListAssActId is table of
76: pay_assignment_latest_balances.assignment_action_id%type
77: index by binary_integer;

Line 76: pay_assignment_latest_balances.assignment_action_id%type

72: type ListLatBalId is table of
73: pay_assignment_latest_balances.latest_balance_id%type
74: index by binary_integer;
75: type ListAssActId is table of
76: pay_assignment_latest_balances.assignment_action_id%type
77: index by binary_integer;
78: type ListValue is table of
79: pay_assignment_latest_balances.value%type
80: index by binary_integer;

Line 79: pay_assignment_latest_balances.value%type

75: type ListAssActId is table of
76: pay_assignment_latest_balances.assignment_action_id%type
77: index by binary_integer;
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;

Line 88: pay_assignment_latest_balances.expired_assignment_action_id%type

84: type ListEffDate is table of
85: date
86: index by binary_integer;
87: type ListExpAssActID is table of
88: pay_assignment_latest_balances.expired_assignment_action_id%type
89: index by binary_integer;
90: type ListExpValue is table of
91: pay_assignment_latest_balances.expired_value%type
92: index by binary_integer;

Line 91: pay_assignment_latest_balances.expired_value%type

87: type ListExpAssActID is table of
88: pay_assignment_latest_balances.expired_assignment_action_id%type
89: index by binary_integer;
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;