PACKAGE: APPS.PAY_CA_EMP_ADDRESS_DTLS

Source

1 package pay_ca_emp_address_dtls as
2 /* $Header: paycaaddwrpr.pkh 120.1 2005/10/05 01:45 saurgupt noship $ */
3 
4 /* Function to fetch the current address details for an employee */
5 function get_emp_address(p_person_id in number,
6                          p_address1  out nocopy varchar2,
7                          p_address2  out nocopy varchar2,
8                          p_address3  out nocopy varchar2,
9                          p_city     out nocopy varchar2,
10                          p_postal_code out nocopy varchar2,
11                          p_country out nocopy varchar2,
12                          p_province out nocopy varchar2) RETURN NUMBER;
13 END pay_ca_emp_address_dtls ;