[Home] [Help]
200: ,lg_format_mask OUT NOCOPY VARCHAR2) IS
201: -- Cursor to retrieve Currency
202: CURSOR csr_currency IS
203: SELECT org_information10
204: FROM hr_organization_information
205: WHERE organization_id = p_business_group_id
206: AND org_information_context = 'Business Group Information';
207: --
208: l_currency VARCHAR2(40);
554: ,greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
555: ,least( p_effective_date, paf.effective_end_date) end_date
556: FROM per_all_assignments_f paf
557: ,hr_soft_coding_keyflex sck
558: ,hr_organization_information hoi
559: ,per_assignment_status_types pas
560: WHERE paf.person_id = p_person_id
561: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
562: AND pas.assignment_status_type_id = paf.assignment_status_type_id
654: SELECT greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
655: ,least( p_effective_date, paf.effective_end_date) end_date
656: FROM per_all_assignments_f paf
657: ,hr_soft_coding_keyflex sck
658: ,hr_organization_information hoi
659: ,per_assignment_status_types pas
660: WHERE paf.person_id = p_person_id
661: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
662: AND pas.assignment_status_type_id = paf.assignment_status_type_id
956: ,hoi2.org_information1 organization_number
957: ,TO_NUMBER(hoi2.org_information5) tax_office_id
958: ,hoi2.org_information2 tax_municipality
959: FROM hr_all_organization_units org
960: ,hr_organization_information hoi1
961: ,hr_organization_information hoi2
962: WHERE p_legal_employer_id IS NULL
963: AND org.business_group_id = p_business_group_id
964: AND hoi1.organization_id = org.organization_id
957: ,TO_NUMBER(hoi2.org_information5) tax_office_id
958: ,hoi2.org_information2 tax_municipality
959: FROM hr_all_organization_units org
960: ,hr_organization_information hoi1
961: ,hr_organization_information hoi2
962: WHERE p_legal_employer_id IS NULL
963: AND org.business_group_id = p_business_group_id
964: AND hoi1.organization_id = org.organization_id
965: AND hoi1.org_information_context = 'CLASS'
972: ,hoi1.org_information1 organization_number
973: ,TO_NUMBER(hoi1.org_information5) tax_office_id
974: ,hoi1.org_information2 tax_municipality
975: FROM hr_all_organization_units org
976: ,hr_organization_information hoi1
977: WHERE p_legal_employer_id IS NOT NULL
978: AND org.organization_id = p_legal_employer_id
979: AND hoi1.organization_id (+) = org.organization_id
980: AND hoi1.org_information_context (+) = 'NO_LEGAL_EMPLOYER_DETAILS';
982: -- Cursor to Extract Other subsidis received (to reduce excemption limit),
983: -- same as in bi-monthly recording sheet, but total for the year (2007/08 changes)
984: --
985:
986: CURSOR csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
987: ,csr_v_business_group_id hr_organization_units.business_group_id%TYPE
988: ,p_report_date DATE) IS
989: SELECT to_number(hoi2.org_information4) economic_aid
990: FROM hr_organization_units o1
987: ,csr_v_business_group_id hr_organization_units.business_group_id%TYPE
988: ,p_report_date DATE) IS
989: SELECT to_number(hoi2.org_information4) economic_aid
990: FROM hr_organization_units o1
991: ,hr_organization_information hoi1
992: ,hr_organization_information hoi2
993: WHERE o1.business_group_id = csr_v_business_group_id
994: AND hoi1.organization_id = o1.organization_id
995: AND hoi1.organization_id = csr_v_legal_emp_id
988: ,p_report_date DATE) IS
989: SELECT to_number(hoi2.org_information4) economic_aid
990: FROM hr_organization_units o1
991: ,hr_organization_information hoi1
992: ,hr_organization_information hoi2
993: WHERE o1.business_group_id = csr_v_business_group_id
994: AND hoi1.organization_id = o1.organization_id
995: AND hoi1.organization_id = csr_v_legal_emp_id
996: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1019: ,nvl(DECODE(hoi.org_information14,'PROCEDURE' , hoi.org_information15),
1020: decode(hoi.org_information14, 'PROCEDURE', hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_DFN'))) rep_summ_dfn
1021: FROM pay_user_tables t
1022: ,pay_user_rows_f r
1023: ,hr_organization_information hoi
1024: WHERE t.user_table_name = 'NO_EOY_CODE_REPORTING_RULES'
1025: AND t.legislation_code = 'NO'
1026: AND r.user_table_id = t.user_table_id
1027: AND r.row_low_range_or_name = hoi.org_information3(+)
1063: FROM pay_user_rows_f r
1064: ,pay_user_tables t
1065: ,pay_user_columns c
1066: ,pay_user_column_instances_f ci
1067: ,hr_organization_information hoi
1068: WHERE t.user_table_name = 'NO_EOY_CODE_REPORTING_RULES'
1069: AND c.user_table_id = t.user_table_id
1070: AND r.user_table_id = t.user_table_id
1071: AND ci.user_row_id = r.user_row_id
1103: ,pay_action_contexts pac2
1104: ,ff_contexts ctx1
1105: ,ff_contexts ctx2
1106: ,hr_lookups lu
1107: ,hr_organization_information orginf1
1108: ,hr_all_organization_units org2
1109: ,hr_organization_information orginf2
1110: ,pay_user_tables t
1111: ,pay_user_rows_f r
1105: ,ff_contexts ctx2
1106: ,hr_lookups lu
1107: ,hr_organization_information orginf1
1108: ,hr_all_organization_units org2
1109: ,hr_organization_information orginf2
1110: ,pay_user_tables t
1111: ,pay_user_rows_f r
1112: WHERE ppa.business_group_id = p_business_group_id
1113: AND paa.payroll_action_id = ppa.payroll_action_id