APPS.PAY_FI_ARCHIVE_PYSA dependencies on HR_GENERAL

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

885: OPEN csr_hire_date(p_assignment_id);
886: FETCH csr_hire_date INTO l_hire_date;
887: CLOSE csr_hire_date;
888: /*NATIONALITY*/
889: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);
890: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');*/
891: /*Local Unit*/
892: OPEN csr_scl_details(p_assignment_id);
893: FETCH csr_scl_details INTO l_local_unit_id;

Line 927: l_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_primary_address.postal_code);

923: FROM hr_organization_units
924: WHERE organization_id = l_legal_employer_id;
925: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
926: IF rec_primary_address.style = 'FI' THEN
927: l_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_primary_address.postal_code);
928: ELSE
929: l_postal_code := rec_primary_address.postal_code;
930: END IF;
931: l_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_primary_address.country);

Line 934: l_emp_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_employer_address.postal_code);

930: END IF;
931: l_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_primary_address.country);
932: /*
933: IF rec_employer_address.style = 'FI' THEN
934: l_emp_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_employer_address.postal_code);
935: ELSE
936: l_emp_postal_code := rec_employer_address.postal_code;
937: END IF;
938: l_emp_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_employer_address.country);

Line 1448: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)

1444: CURSOR csr_leave_balance
1445: IS
1446: --
1447: SELECT pap.accrual_plan_name
1448: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
1449: ,pap.accrual_units_of_measure
1450: ,ppa.payroll_id
1451: ,pap.business_group_id
1452: ,pap.accrual_plan_id

Line 2005: l_tax_card_type := hr_general.decode_lookup('FI_TAX_CARD_TYPE',l_tax_card_type ) ;

2001: l_previous_income := l_rec.screen_entry_value ;
2002: l_tax_card_effective_date := l_tax_rec.effective_start_date;
2003: END IF;
2004:
2005: l_tax_card_type := hr_general.decode_lookup('FI_TAX_CARD_TYPE',l_tax_card_type ) ;
2006:
2007: pay_action_information_api.create_action_information (
2008: p_action_information_id => l_action_info_id
2009: ,p_action_context_id => p_archive_assact_id

Line 2995: l_emp_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_employer_address.postal_code);

2991: FOR rec_employer_address IN csr_employer_address(csr_legal_emp_rec.organization_id)
2992: LOOP
2993:
2994: IF rec_employer_address.style = 'FI' THEN
2995: l_emp_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_employer_address.postal_code);
2996: ELSE
2997: l_emp_postal_code := rec_employer_address.postal_code;
2998: END IF;
2999: l_emp_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_employer_address.country);