1196: pa.region_2
1197: r2, pa.region_3 r3, pa.town_or_city city, pa.address_line1 al1, pa.address_line2 al2,
1198: pa.address_line3
1199: al3, pa.postal_code postal_code
1200: from per_addresses pa
1201: where pa.primary_flag = 'Y'
1202: and pa.person_id = p_person_id
1203: and p_effective_date between pa.date_from and nvl (pa.date_to, to_date ('31-12-4712', 'DD-MM-YYYY'));
1204:
1210: pa.region_2
1211: r2, pa.region_3 r3, pa.town_or_city city, pa.address_line1 al1, pa.address_line2 al2,
1212: pa.address_line3
1213: al3, pa.postal_code postal_code
1214: from per_addresses pa
1215: where pa.address_type = 'FI_PR'
1216: and pa.person_id = p_person_id
1217: and p_effective_date between pa.date_from and nvl (pa.date_to, to_date ('31-12-4712', 'DD-MM-YYYY'));
1218:
1251: and p_effective_date between effective_start_date and nvl (effective_end_date, p_effective_date);
1252:
1253: l_balance_name pay_balance_types.balance_name%type;
1254: rl_primary_address csr_primary_address%rowtype;
1255: l_postal_code per_addresses.postal_code%type;
1256: l_country per_addresses.country%type;
1257: rl_permanent_address csr_permanent_address%rowtype;
1258: l_permanent_postal_code per_addresses.postal_code%type;
1259: l_permanent_country per_addresses.country%type;
1252:
1253: l_balance_name pay_balance_types.balance_name%type;
1254: rl_primary_address csr_primary_address%rowtype;
1255: l_postal_code per_addresses.postal_code%type;
1256: l_country per_addresses.country%type;
1257: rl_permanent_address csr_permanent_address%rowtype;
1258: l_permanent_postal_code per_addresses.postal_code%type;
1259: l_permanent_country per_addresses.country%type;
1260: l_payroll_id pay_action_information.action_information3%type;
1254: rl_primary_address csr_primary_address%rowtype;
1255: l_postal_code per_addresses.postal_code%type;
1256: l_country per_addresses.country%type;
1257: rl_permanent_address csr_permanent_address%rowtype;
1258: l_permanent_postal_code per_addresses.postal_code%type;
1259: l_permanent_country per_addresses.country%type;
1260: l_payroll_id pay_action_information.action_information3%type;
1261: l_pay_period pay_action_information.action_information4%type;
1262: l_pay_period_start_date pay_action_information.action_information5%type;
1255: l_postal_code per_addresses.postal_code%type;
1256: l_country per_addresses.country%type;
1257: rl_permanent_address csr_permanent_address%rowtype;
1258: l_permanent_postal_code per_addresses.postal_code%type;
1259: l_permanent_country per_addresses.country%type;
1260: l_payroll_id pay_action_information.action_information3%type;
1261: l_pay_period pay_action_information.action_information4%type;
1262: l_pay_period_start_date pay_action_information.action_information5%type;
1263: l_pay_period_end_date pay_action_information.action_information3%type;
1690: pa.region_2
1691: r2, pa.region_3 r3, pa.town_or_city city, pa.address_line1 al1, pa.address_line2 al2,
1692: pa.address_line3
1693: al3, pa.postal_code postal_code
1694: from per_addresses pa
1695: where pa.primary_flag = 'Y'
1696: and pa.person_id = p_person_id
1697: and g_year_last_date between pa.date_from and nvl (pa.date_to, to_date ('31-12-4712', 'DD-MM-YYYY'));
1698:
1704: pa.region_2
1705: r2, pa.region_3 r3, pa.town_or_city city, pa.address_line1 al1, pa.address_line2 al2,
1706: pa.address_line3
1707: al3, pa.postal_code postal_code
1708: from per_addresses pa
1709: where pa.address_type = 'FI_PR'
1710: and pa.person_id = p_person_id
1711: and g_year_last_date between pa.date_from and nvl (pa.date_to, to_date ('31-12-4712', 'DD-MM-YYYY'));
1712:
1710: and pa.person_id = p_person_id
1711: and g_year_last_date between pa.date_from and nvl (pa.date_to, to_date ('31-12-4712', 'DD-MM-YYYY'));
1712:
1713: rl_primary_address csr_primary_address%rowtype;
1714: l_postal_code per_addresses.postal_code%type;
1715: l_country per_addresses.country%type;
1716: rl_permanent_address csr_primary_address%rowtype;
1717: l_permanent_postal_code per_addresses.postal_code%type;
1718: l_permanent_country per_addresses.country%type;
1711: and g_year_last_date between pa.date_from and nvl (pa.date_to, to_date ('31-12-4712', 'DD-MM-YYYY'));
1712:
1713: rl_primary_address csr_primary_address%rowtype;
1714: l_postal_code per_addresses.postal_code%type;
1715: l_country per_addresses.country%type;
1716: rl_permanent_address csr_primary_address%rowtype;
1717: l_permanent_postal_code per_addresses.postal_code%type;
1718: l_permanent_country per_addresses.country%type;
1719: l_action_info_id number;
1713: rl_primary_address csr_primary_address%rowtype;
1714: l_postal_code per_addresses.postal_code%type;
1715: l_country per_addresses.country%type;
1716: rl_permanent_address csr_primary_address%rowtype;
1717: l_permanent_postal_code per_addresses.postal_code%type;
1718: l_permanent_country per_addresses.country%type;
1719: l_action_info_id number;
1720: l_ovn number;
1721: begin
1714: l_postal_code per_addresses.postal_code%type;
1715: l_country per_addresses.country%type;
1716: rl_permanent_address csr_primary_address%rowtype;
1717: l_permanent_postal_code per_addresses.postal_code%type;
1718: l_permanent_country per_addresses.country%type;
1719: l_action_info_id number;
1720: l_ovn number;
1721: begin
1722: open csr_primary_address (p_person_id);