APPS.PAY_CA_BALANCE_VIEW_PKG dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 36: lat_balid pay_assignment_latest_balances.latest_balance_id%type,

32: type LatBal is record
33: (
34: -- latest_balance_id
35: --
36: lat_balid pay_assignment_latest_balances.latest_balance_id%type,
37: --
38: -- latest balance
39: --
40: assactid pay_assignment_latest_balances.assignment_action_id%type,

Line 40: assactid pay_assignment_latest_balances.assignment_action_id%type,

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

Line 41: value pay_assignment_latest_balances.value%type,

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

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

43: effdate date,
44: --
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: --

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

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

Line 54: exp_assactid pay_assignment_latest_balances.expired_assignment_action_id%type,

50: -- prv_effdate date,
51: --
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: );

Line 55: exp_value pay_assignment_latest_balances.expired_value%type,

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

Line 67: pay_assignment_latest_balances.latest_balance_id%type

63: -- BHOMAN - can't PLSQL tables of records, so replace LatBalList
64: -- with individual tables for each element
65: -- type LatBalList is table of LatBal index by binary_integer;
66: type ListLatBalId is table of
67: pay_assignment_latest_balances.latest_balance_id%type
68: index by binary_integer;
69: type ListAssActId is table of
70: pay_assignment_latest_balances.assignment_action_id%type
71: index by binary_integer;

Line 70: pay_assignment_latest_balances.assignment_action_id%type

66: type ListLatBalId is table of
67: pay_assignment_latest_balances.latest_balance_id%type
68: index by binary_integer;
69: type ListAssActId is table of
70: pay_assignment_latest_balances.assignment_action_id%type
71: index by binary_integer;
72: type ListValue is table of
73: pay_assignment_latest_balances.value%type
74: index by binary_integer;

Line 73: pay_assignment_latest_balances.value%type

69: type ListAssActId is table of
70: pay_assignment_latest_balances.assignment_action_id%type
71: index by binary_integer;
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;

Line 82: pay_assignment_latest_balances.expired_assignment_action_id%type

78: type ListEffDate is table of
79: date
80: index by binary_integer;
81: type ListExpAssActID is table of
82: pay_assignment_latest_balances.expired_assignment_action_id%type
83: index by binary_integer;
84: type ListExpValue is table of
85: pay_assignment_latest_balances.expired_value%type
86: index by binary_integer;

Line 85: pay_assignment_latest_balances.expired_value%type

81: type ListExpAssActID is table of
82: pay_assignment_latest_balances.expired_assignment_action_id%type
83: 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;