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: l_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_primary_address.country);

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

969: END IF;
970: l_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_primary_address.country);
971: /*
972: IF rec_employer_address.style = 'SE' THEN
973: l_emp_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_employer_address.postal_code);
974: ELSE
975: l_emp_postal_code := rec_employer_address.postal_code;
976: END IF;
977: l_emp_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);

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

2520: l_tax_card_effective_date := l_tax_rec.effective_start_date;
2521: END IF;
2522: */
2523:
2524: l_tax_card_type := hr_general.decode_lookup('SE_TAX_CARD_TYPE',l_tax_card_type ) ;
2525:
2526: pay_action_information_api.create_action_information (
2527: p_action_information_id => l_action_info_id
2528: ,p_action_context_id => p_archive_assact_id

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

3837: FOR rec_employer_address IN csr_employer_address(csr_legal_emp_rec.organization_id)
3838: LOOP
3839:
3840: IF rec_employer_address.style = 'FI' THEN
3841: l_emp_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_employer_address.postal_code);
3842: ELSE
3843: l_emp_postal_code := rec_employer_address.postal_code;
3844: END IF;
3845: l_emp_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);