DBA Data[Home] [Help]

APPS.PAY_NL_ANNUAL_SI_FILE dependencies on PAY_NL_TAXOFFICE_ARCHIVE

Line 523: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_tax_year_end_date);

519:
520: l_tax_year := to_char(l_tax_year_date,'YYYY');
521: l_tax_year_start_date := to_date('01/01/'||l_tax_year,'DD/MM/YYYY');
522: l_tax_year_end_date := to_date('31/12/'||l_tax_year,'DD/MM/YYYY');
523: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_tax_year_end_date);
524: l_ASI_Process_Date := l_tax_year_end_date;
525:
526:
527: --hr_utility.trace(l_tax_year_start_date);

Line 727: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_tax_year_end_date);

723:
724: l_tax_year := to_char(l_tax_year_date,'YYYY');
725: l_tax_year_start_date := to_date('01/01/'||l_tax_year,'DD/MM/YYYY');
726: l_tax_year_end_date := to_date('31/12/'||l_tax_year,'DD/MM/YYYY');
727: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_tax_year_end_date);
728: l_ASI_Process_Date := l_tax_year_end_date;
729:
730:
731: --hr_utility.trace(l_tax_year_start_date);

Line 753: l_max_assgt_act_id := pay_nl_taxoffice_archive.get_max_assgt_act_id(l_assignment_id,l_tax_year_start_date,l_tax_year_end_date);

749: g_full_name:=process_rec.full_name;
750: g_error_count := 0;
751: -- Fetch Action to be locked into l_max_assgt_act_id
752:
753: l_max_assgt_act_id := pay_nl_taxoffice_archive.get_max_assgt_act_id(l_assignment_id,l_tax_year_start_date,l_tax_year_end_date);
754: IF l_max_assgt_act_id IS NOT NULL THEN
755: /*Create the Assignment Action for the Assignment
756: and Lock the Latest Payroll Run Assignment Action for the Assignment
757: */