DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on HR_GENERAL

Line 928: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);

924: OPEN csr_hire_date(p_assignment_id);
925: FETCH csr_hire_date INTO l_hire_date;
926: CLOSE csr_hire_date;
927: /*NATIONALITY*/
928: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);
929: --fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');
930: /*Local Unit*/
931: OPEN csr_scl_details(p_assignment_id);
932: FETCH csr_scl_details INTO l_local_unit_id;

Line 966: l_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_primary_address.postal_code);

962: FROM hr_organization_units
963: WHERE organization_id = l_legal_employer_id;
964: --fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');
965: IF rec_primary_address.style = 'SE' THEN
966: l_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_primary_address.postal_code);
967: ELSE
968: l_postal_code := rec_primary_address.postal_code;
969: END IF;
970: --Bug#8849455 fix Added space between 3 and 4 digits in postal code

Line 975: l_emp_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_employer_address.postal_code);

971: l_postal_code := substr(l_postal_code,1,3)||' '||substr(l_postal_code,4,2);
972: l_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_primary_address.country);
973: /*
974: IF rec_employer_address.style = 'SE' THEN
975: l_emp_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_employer_address.postal_code);
976: ELSE
977: l_emp_postal_code := rec_employer_address.postal_code;
978: END IF;
979: l_emp_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);

Line 2536: l_tax_card_type := hr_general.decode_lookup('SE_TAX_CARD_TYPE',l_tax_card_type ) ;

2532: l_tax_card_effective_date := l_tax_rec.effective_start_date;
2533: END IF;
2534: */
2535:
2536: l_tax_card_type := hr_general.decode_lookup('SE_TAX_CARD_TYPE',l_tax_card_type ) ;
2537:
2538: pay_action_information_api.create_action_information (
2539: p_action_information_id => l_action_info_id
2540: ,p_action_context_id => p_archive_assact_id

Line 3866: l_emp_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_employer_address.postal_code);

3862: FOR rec_employer_address IN csr_employer_address(csr_legal_emp_rec.organization_id)
3863: LOOP
3864:
3865: IF rec_employer_address.style = 'FI' THEN
3866: l_emp_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_employer_address.postal_code);
3867: ELSE
3868: l_emp_postal_code := rec_employer_address.postal_code;
3869: END IF;
3870: -- Bug#8849455 fix Added space between 3 and 4 digits in postal code