APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on STANDARD

Line 332: -- PAYE at Higher Rate and PAYE at Standard Rate

328:
329:
330: -- Bug No: 2338289
331: -- Deduction Net Tax (and value) not to be shown, it should be
332: -- PAYE at Higher Rate and PAYE at Standard Rate
333: -- csr_element_name modified
334:
335: CURSOR csr_element_name (p_business_group_id NUMBER,
336: p_effective_date DATE) IS

Line 371: OR (pet.element_name in ('IE PAYE at higher rate','IE PAYE at standard rate') AND piv.name ='Value' ))

367: AND piv.element_type_id = pet.element_type_id
368: AND (
369: (piv.name ='Pay Value' )
370: OR (pet.element_name in ('IE BIK Arrearage Details','IE BIK Arrearage Recovery Details') and piv.name in ('BIK Arrearage','BIK Arrearage Recovered'))
371: OR (pet.element_name in ('IE PAYE at higher rate','IE PAYE at standard rate') AND piv.name ='Value' ))
372: AND p_effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date
373: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
374: Union -- Added for bug Fix 2367175
375: SELECT pet.element_type_id,piv.input_value_id,

Line 520: PROCEDURE setup_standard_balance_table

516: hr_utility.set_location('Leaving ' || l_proc,30);
517:
518: END setup_element_definitions;
519:
520: PROCEDURE setup_standard_balance_table
521: IS
522:
523: TYPE balance_name_rec IS RECORD (
524: balance_name VARCHAR2(30));

Line 565: l_proc VARCHAR2(120) := g_package || 'setup_standard_balance_table';

561: l_dimension_2 VARCHAR2(20) := '_PER_PAYE_REF_YTD';
562: l_found VARCHAR2(1);
563: l_max_stat_balance NUMBER := 14;
564:
565: l_proc VARCHAR2(120) := g_package || 'setup_standard_balance_table';
566: l_index_id NUMBER := 0;
567:
568: l_dimension_3 VARCHAR2(50) := '_PER_PAYE_REF_PPSN_YTD'; --6633719
569:

Line 742: END setup_standard_balance_table;

738: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
739:
740: hr_utility.set_location('Leaving ' || l_proc,60);
741:
742: END setup_standard_balance_table;
743:
744:
745:
746:

Line 891: l_std_cut_off_value := 'Weekly Standard Rate Cutoff';

887: hr_utility.set_location('l_payroll_type = '|| l_payroll_type, 30);
888:
889: IF l_payroll_type in ('Week', 'Bi-Week', 'Lunar Month') THEN
890: l_tax_credit_value := 'Weekly Tax Credit';
891: l_std_cut_off_value := 'Weekly Standard Rate Cutoff';
892:
893: ELSE
894:
895: l_tax_credit_value := 'Monthly Tax Credit';

Line 896: l_std_cut_off_value := 'Monthly Standard Rate Cutoff';

892:
893: ELSE
894:
895: l_tax_credit_value := 'Monthly Tax Credit';
896: l_std_cut_off_value := 'Monthly Standard Rate Cutoff';
897:
898: END IF;
899:
900: hr_utility.set_location('l_tax_credit_value = '|| l_tax_credit_value, 30);

Line 998: pay_ie_legislative_archive.setup_standard_balance_table;

994: , p_payroll_action_id);
995:
996: -- setup statutory balances pl/sql table
997:
998: pay_ie_legislative_archive.setup_standard_balance_table;
999:
1000: hr_utility.set_location('Leaving ' || l_proc,20);
1001: --
1002: