APPS.PAY_GB_EOY_MAGTAPE dependencies on PAY_GB_YEAR_END_VALUES_V

Line 316: g_rollup_lel_ni_cat pay_gb_year_end_values_v.ni_category_code%TYPE;

312: ni_able_auel_tab balance_tab_typ; --- EOY 07/08
313: employers_rebate_tab balance_tab_typ;
314: employees_rebate_tab balance_tab_typ;
315: --
316: g_rollup_lel_ni_cat pay_gb_year_end_values_v.ni_category_code%TYPE;
317: g_total_rollup_lel pay_gb_year_end_values_v.ni_able_lel%TYPE;
318: --
319: g_emp_tot_lel NUMBER; -- total of NI ABle LEL for agg asgs (not NI X)
320: g_emp_tot_et NUMBER; -- total of NI ABle ET for agg asgs (not NI X)

Line 317: g_total_rollup_lel pay_gb_year_end_values_v.ni_able_lel%TYPE;

313: employers_rebate_tab balance_tab_typ;
314: employees_rebate_tab balance_tab_typ;
315: --
316: g_rollup_lel_ni_cat pay_gb_year_end_values_v.ni_category_code%TYPE;
317: g_total_rollup_lel pay_gb_year_end_values_v.ni_able_lel%TYPE;
318: --
319: g_emp_tot_lel NUMBER; -- total of NI ABle LEL for agg asgs (not NI X)
320: g_emp_tot_et NUMBER; -- total of NI ABle ET for agg asgs (not NI X)
321: g_emp_tot_uel NUMBER; -- total of NI ABle UEL for agg asgs (not NI X)

Line 481: FROM pay_gb_year_end_values_v a

477: --
478: CURSOR get_rollup_ni_cat(c_assignment_action_id NUMBER) IS
479: SELECT NVL(UPPER(a.scon),' ') scon
480: ,UPPER(a.ni_category_code) cat_code
481: FROM pay_gb_year_end_values_v a
482: WHERE a.assignment_action_id = c_assignment_action_id
483: AND a.reportable <> 'N'
484: AND NVL(trunc(a.ni_able_uel/100),0) > 0
485: AND NVL(a.employees_contributions,0) > 0

Line 496: FROM pay_gb_year_end_values_v a

492: -- no other values can be rolledup into this
493: --
494: CURSOR get_lel_rollup_ni_cat(c_assignment_action_id NUMBER) IS
495: SELECT UPPER(a.ni_category_code) cat_code
496: FROM pay_gb_year_end_values_v a
497: WHERE a.assignment_action_id = c_assignment_action_id
498: AND a.reportable <> 'N'
499: AND NVL(trunc(a.ni_able_et/100),0) > 0
500: AND NVL(trunc(a.ni_able_lel/100),0) > 0

Line 514: FROM pay_gb_year_end_values_v a

510: -- returned by above cursor get_lel_rollup_ni_cat
511: --
512: CURSOR get_only_lel_total(c_assignment_action_id NUMBER) IS
513: SELECT NVL(sum(trunc(a.ni_able_lel/100)),0) tot_ni_able_lel
514: FROM pay_gb_year_end_values_v a
515: WHERE a.assignment_action_id = c_assignment_action_id
516: AND a.reportable <> 'N'
517: AND UPPER(a.ni_category_code) <> 'X'
518: -- Check LEL > 0 but ET, UEL, EE and ER Conrib = 0

Line 539: FROM pay_gb_year_end_values_v a

535: ,NVL(trunc(a.ni_able_uel/100),0) ni_able_uel
536: ,NVL(trunc(a.ni_able_auel/100),0) ni_able_auel --EOY 07/08 added AUEL for contributions rollup
537: ,NVL(a.employers_rebate,0) employers_rebate
538: ,NVL(a.employees_rebate,0) employees_rebate
539: FROM pay_gb_year_end_values_v a
540: WHERE a.assignment_action_id = c_assignment_action_id
541: AND a.reportable <> 'N'
542: -- Check atleast one value is non-zero to report
543: AND NOT (NVL(a.total_contributions,0) = 0

Line 561: (SELECT 1 FROM pay_gb_year_end_values_v b

557: ,0
558: ,0
559: FROM dual
560: WHERE NOT EXISTS
561: (SELECT 1 FROM pay_gb_year_end_values_v b
562: WHERE b.assignment_action_id = c_assignment_action_id
563: AND b.reportable <> 'N'
564: AND NOT (NVL(b.total_contributions,0) = 0
565: AND NVL(trunc(b.ni_able_et/100),0) = 0