eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_CBS_FILE dependencies on HR_NL_ORG_INFO

Line 830: -- l_public_sector_org := hr_nl_org_info.Get_Public_Sector_Org(p_org_id);

826: l_grade_number number;
827:
828: Begin
829:
830: -- l_public_sector_org := hr_nl_org_info.Get_Public_Sector_Org(p_org_id);
831: -- hr_utility.set_location('--Entering get_grade_salary_number ',10);
832:
833: if P_public_sector = 'Y' then
834: Open csr_get_grade_number(p_grade_id,p_business_group_id);

Line 1113: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer);

1109: l_tax_address_field := l_street_name || l_house_number || l_house_no_add;
1110: l_tax_city_field := l_postal_code || l_city;
1111: -- hr_utility.set_location('Going to retrieve the Data of org struct id,frequency and cust no'||l_reporting_date,600);
1112: l_org_struct_version_id := pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);
1113: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer);
1114: l_customer_number := hr_nl_org_info.get_customer_number(l_employer);
1115:
1116: -- hr_utility.set_location('Going to perform mandatory check the Data in Range Code',600);
1117:

Line 1114: l_customer_number := hr_nl_org_info.get_customer_number(l_employer);

1110: l_tax_city_field := l_postal_code || l_city;
1111: -- hr_utility.set_location('Going to retrieve the Data of org struct id,frequency and cust no'||l_reporting_date,600);
1112: l_org_struct_version_id := pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);
1113: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer);
1114: l_customer_number := hr_nl_org_info.get_customer_number(l_employer);
1115:
1116: -- hr_utility.set_location('Going to perform mandatory check the Data in Range Code',600);
1117:
1118: Mandatory_Check('PAY_NL_ER_REQUIRED_FIELD','NL_SENDER_NAME', l_Sender_Rep_Name_bg);

Line 1206: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'ZFW',p_assignment_id);

1202: BEGIN
1203:
1204: -- hr_utility.set_location('Entering check_Asg_si_provider funciton ',600);
1205:
1206: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'ZFW',p_assignment_id);
1207: IF ( l_si_provider_id = p_si_provider_id) THEN
1208: RETURN 1;
1209: END IF;
1210: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'ZW',p_assignment_id);

Line 1210: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'ZW',p_assignment_id);

1206: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'ZFW',p_assignment_id);
1207: IF ( l_si_provider_id = p_si_provider_id) THEN
1208: RETURN 1;
1209: END IF;
1210: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'ZW',p_assignment_id);
1211: IF ( l_si_provider_id = p_si_provider_id) THEN
1212: RETURN 1;
1213: END IF;
1214: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WEWE',p_assignment_id);

Line 1214: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WEWE',p_assignment_id);

1210: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'ZW',p_assignment_id);
1211: IF ( l_si_provider_id = p_si_provider_id) THEN
1212: RETURN 1;
1213: END IF;
1214: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WEWE',p_assignment_id);
1215: IF ( l_si_provider_id = p_si_provider_id) THEN
1216: RETURN 1;
1217: END IF;
1218: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WEWA',p_assignment_id);

Line 1218: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WEWA',p_assignment_id);

1214: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WEWE',p_assignment_id);
1215: IF ( l_si_provider_id = p_si_provider_id) THEN
1216: RETURN 1;
1217: END IF;
1218: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WEWA',p_assignment_id);
1219: IF ( l_si_provider_id = p_si_provider_id) THEN
1220: RETURN 1;
1221: END IF;
1222: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WAOB',p_assignment_id);

Line 1222: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WAOB',p_assignment_id);

1218: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WEWA',p_assignment_id);
1219: IF ( l_si_provider_id = p_si_provider_id) THEN
1220: RETURN 1;
1221: END IF;
1222: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WAOB',p_assignment_id);
1223: IF ( l_si_provider_id = p_si_provider_id) THEN
1224: RETURN 1;
1225: END IF;
1226: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WAOD',p_assignment_id);

Line 1226: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WAOD',p_assignment_id);

1222: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WAOB',p_assignment_id);
1223: IF ( l_si_provider_id = p_si_provider_id) THEN
1224: RETURN 1;
1225: END IF;
1226: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'WAOD',p_assignment_id);
1227: IF ( l_si_provider_id = p_si_provider_id) THEN
1228: RETURN 1;
1229: else
1230: return 0;

Line 1325: (select hr_nl_org_info.get_tax_org_id(p_org_struct_version_id,paa.organization_id) from dual)

1321: and asg.effective_start_date <= p_reporting_End_Date
1322: and nvl(asg.effective_end_date, p_reporting_End_Date) >= p_reporting_Start_Date
1323: )
1324: and p_employer_id in
1325: (select hr_nl_org_info.get_tax_org_id(p_org_struct_version_id,paa.organization_id) from dual)
1326: and not exists
1327: (select 1
1328: from
1329: pay_action_information ee_ats

Line 1448: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer_id);

1444: hr_utility.set_location('p_business_group_id'||l_business_group_id,425);
1445: end if;
1446:
1447: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);
1448: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer_id);
1449:
1450: -- hr_utility.set_location('l_frequency'||l_frequency,425);
1451: if l_frequency = 'K' then
1452: l_reporting_start_date := ADD_MONTHS(l_reporting_date,-3);

Line 1525: if (hr_nl_org_info.Get_Full_Sickness_Wage_Paid (l_employer_id) <> 'Y')

1521: l_paid_gross_wage := 0;
1522: l_wage_for_overtime := 0;
1523:
1524: -- Check for the Full sickness wage paid at the org level
1525: if (hr_nl_org_info.Get_Full_Sickness_Wage_Paid (l_employer_id) <> 'Y')
1526: then l_sickness_days := 99;
1527: l_sickness_pay := 9999999;
1528: end if;
1529: -- hr_utility.set_location('fetched full sickness wage paid'||l_asg_term,600);

Line 1556: if (hr_nl_org_info.Get_Full_Sickness_Wage_Paid (l_employer_id) <> 'Y')

1552: ,l_si_days_quarter
1553: ,l_paid_gross_wage
1554: ,l_wage_for_overtime);
1555:
1556: if (hr_nl_org_info.Get_Full_Sickness_Wage_Paid (l_employer_id) <> 'Y')
1557: then l_sickness_days := 99;
1558: l_sickness_pay := 9999999;
1559: end if;
1560:

Line 1569: l_public_sector := hr_nl_org_info.Get_Public_Sector_Org(l_employer_id);

1565: get_cao_code(l_assignment_id,l_cao_code,l_reporting_date);
1566: get_dev_work_hours(l_assignment_id,l_deviating_working_hours,l_reporting_start_date,l_reporting_end_date);
1567:
1568: l_number:= get_employment_code(l_assignment_id,l_employment_code,l_reporting_start_date,l_reporting_end_date);
1569: l_public_sector := hr_nl_org_info.Get_Public_Sector_Org(l_employer_id);
1570: l_number := get_grade_salary_number(l_assignment_id,l_business_group_id,l_employer_id,l_grade_id,l_reporting_date
1571: ,l_public_sector,l_grade_number,l_salary_number);
1572: l_unpaid_hours1 := fnd_number.number_to_canonical(l_unpaid_hours);
1573: l_overtime_hours1 := fnd_number.number_to_canonical(l_overtime_hours);