APPS.PAY_GB_EOY dependencies on PAY_GB_YEAR_END_VALUES

Line 99: TYPE scon_typ IS TABLE OF pay_gb_year_end_values.scon%TYPE

95: g_postal_code VARCHAR2(8);
96: --
97: /* PL/SQL table definitions */
98: --
99: TYPE scon_typ IS TABLE OF pay_gb_year_end_values.scon%TYPE
100: INDEX BY BINARY_INTEGER;
101: TYPE category_typ IS TABLE OF pay_gb_year_end_values.ni_category_code%TYPE
102: INDEX BY BINARY_INTEGER;
103: TYPE earnings_typ IS TABLE OF pay_gb_year_end_values.earnings%TYPE

Line 101: TYPE category_typ IS TABLE OF pay_gb_year_end_values.ni_category_code%TYPE

97: /* PL/SQL table definitions */
98: --
99: TYPE scon_typ IS TABLE OF pay_gb_year_end_values.scon%TYPE
100: INDEX BY BINARY_INTEGER;
101: TYPE category_typ IS TABLE OF pay_gb_year_end_values.ni_category_code%TYPE
102: INDEX BY BINARY_INTEGER;
103: TYPE earnings_typ IS TABLE OF pay_gb_year_end_values.earnings%TYPE
104: INDEX BY BINARY_INTEGER;
105: TYPE total_contrib_typ IS TABLE OF

Line 103: TYPE earnings_typ IS TABLE OF pay_gb_year_end_values.earnings%TYPE

99: TYPE scon_typ IS TABLE OF pay_gb_year_end_values.scon%TYPE
100: INDEX BY BINARY_INTEGER;
101: TYPE category_typ IS TABLE OF pay_gb_year_end_values.ni_category_code%TYPE
102: INDEX BY BINARY_INTEGER;
103: TYPE earnings_typ IS TABLE OF pay_gb_year_end_values.earnings%TYPE
104: INDEX BY BINARY_INTEGER;
105: TYPE total_contrib_typ IS TABLE OF
106: pay_gb_year_end_values.total_contributions%TYPE
107: INDEX BY BINARY_INTEGER;

Line 106: pay_gb_year_end_values.total_contributions%TYPE

102: INDEX BY BINARY_INTEGER;
103: TYPE earnings_typ IS TABLE OF pay_gb_year_end_values.earnings%TYPE
104: INDEX BY BINARY_INTEGER;
105: TYPE total_contrib_typ IS TABLE OF
106: pay_gb_year_end_values.total_contributions%TYPE
107: INDEX BY BINARY_INTEGER;
108: TYPE emps_contrib_typ IS TABLE OF
109: pay_gb_year_end_values.employees_contributions%TYPE
110: INDEX BY BINARY_INTEGER;

Line 109: pay_gb_year_end_values.employees_contributions%TYPE

105: TYPE total_contrib_typ IS TABLE OF
106: pay_gb_year_end_values.total_contributions%TYPE
107: INDEX BY BINARY_INTEGER;
108: TYPE emps_contrib_typ IS TABLE OF
109: pay_gb_year_end_values.employees_contributions%TYPE
110: INDEX BY BINARY_INTEGER;
111: TYPE earnings_cont_out_typ IS TABLE OF
112: pay_gb_year_end_values.earnings_contracted_out%TYPE
113: INDEX BY BINARY_INTEGER;

Line 112: pay_gb_year_end_values.earnings_contracted_out%TYPE

108: TYPE emps_contrib_typ IS TABLE OF
109: pay_gb_year_end_values.employees_contributions%TYPE
110: INDEX BY BINARY_INTEGER;
111: TYPE earnings_cont_out_typ IS TABLE OF
112: pay_gb_year_end_values.earnings_contracted_out%TYPE
113: INDEX BY BINARY_INTEGER;
114: TYPE contribs_cont_out_typ IS TABLE OF
115: pay_gb_year_end_values.contributions_contracted_out%TYPE
116: INDEX BY BINARY_INTEGER;

Line 115: pay_gb_year_end_values.contributions_contracted_out%TYPE

111: TYPE earnings_cont_out_typ IS TABLE OF
112: pay_gb_year_end_values.earnings_contracted_out%TYPE
113: INDEX BY BINARY_INTEGER;
114: TYPE contribs_cont_out_typ IS TABLE OF
115: pay_gb_year_end_values.contributions_contracted_out%TYPE
116: INDEX BY BINARY_INTEGER;
117: --
118: scon_tab scon_typ;
119: category_tab category_typ;

Line 203: FROM pay_gb_year_end_values a

199: ,NVL(a.total_contributions,0) tot_cont
200: ,NVL(a.employees_contributions,0) emps_cont
201: ,NVL(TRUNC(a.earnings_contracted_out/100),0) earnings_out
202: ,NVL(a.contributions_contracted_out,0) cont_out
203: FROM pay_gb_year_end_values a
204: WHERE a.assignment_id = cp_assignment_id
205: AND a.effective_end_date = cp_effective_date
206: AND a.reportable <> 'N';
207: --

Line 213: FROM pay_gb_year_end_values a

209: ,cp_tax_dist_ref VARCHAR2
210: ,cp_tax_ref_no VARCHAR2
211: ,cp_business_group_id NUMBER) IS
212: SELECT '1'
213: FROM pay_gb_year_end_values a
214: WHERE a.ni_category_code IN ('D','E')
215: AND (a.assignment_id,a.effective_end_date) IN
216: (SELECT b.assignment_id,b.effective_end_date
217: FROM pay_gb_year_end_assignments b