DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_DEFINED_BALANCES

Line 46: g_fbt_defined_balance_id pay_defined_balances.defined_balance_id%TYPE :=0;

42: g_tot_tax_ded_bal_typ_id pay_balance_types.balance_type_id%type;
43: /* End Bug#3004966 */
44: g_index number:=0; /* Bug#3215982 */
45: /* Bug 3034198 */
46: g_fbt_defined_balance_id pay_defined_balances.defined_balance_id%TYPE :=0;
47: /* End bug 3034189 */
48:
49: /*------- Bug# 3193479 ---------------------------------------------------------------*/
50:

Line 95: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)

91: p_output_tab OUT NOCOPY bal_tab,
92: p_message OUT NOCOPY VARCHAR2 /* Bug#4863149 */
93: );
94: -- TO return the value from plsql table populated by BBR
95: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
96: return number;
97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;

Line 98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;

94: -- TO return the value from plsql table populated by BBR
95: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
96: return number;
97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;

Line 99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;

95: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
96: return number;
97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;

Line 100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */

96: return number;
97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;

Line 101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;

97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;

Line 102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;

98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;

Line 103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;

99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;

Line 104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;

100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;

Line 105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;

101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;

Line 106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;

102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;

Line 107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;

103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;

Line 108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;

104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;

Line 109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;

105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;

Line 110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;

106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;

Line 111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;

107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;

Line 112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;

108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
116:

Line 113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;

109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
116:
117:

Line 114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;

110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
116:
117:
118:

Line 115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;

111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
116:
117:
118:
119: /*--------end of Bug# 3193479---------------------------------------------------------------*/