DBA Data[Home] [Help]

APPS.PAY_CA_EMP_ADDRESS_DTLS dependencies on PAY_CA_RL1_REG

Line 13: addr pay_ca_rl1_reg.primaryaddress ;

9: p_country out nocopy varchar2,
10: p_province out nocopy varchar2 ) return Number is
11:
12: /* Local Variables */
13: addr pay_ca_rl1_reg.primaryaddress ;
14:
15: begin
16:
17: addr := pay_ca_rl1_reg.get_primary_address(p_person_id,sysdate);

Line 17: addr := pay_ca_rl1_reg.get_primary_address(p_person_id,sysdate);

13: addr pay_ca_rl1_reg.primaryaddress ;
14:
15: begin
16:
17: addr := pay_ca_rl1_reg.get_primary_address(p_person_id,sysdate);
18:
19: p_address1 := nvl(addr.addr_line_1,' ');
20: p_address2 := nvl(rtrim(ltrim(addr.addr_line_2)),' ');
21: p_address3 := nvl(rtrim(ltrim(addr.addr_line_3)),' ');