DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on PER_ADDRESSES

Line 1200: from per_addresses pa

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:

Line 1214: from per_addresses pa

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:

Line 1255: l_postal_code per_addresses.postal_code%type;

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;

Line 1256: l_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;

Line 1258: l_permanent_postal_code per_addresses.postal_code%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;

Line 1259: l_permanent_country per_addresses.country%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;

Line 1694: from per_addresses pa

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:

Line 1708: from per_addresses pa

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:

Line 1714: l_postal_code per_addresses.postal_code%type;

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;

Line 1715: l_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;

Line 1717: l_permanent_postal_code per_addresses.postal_code%type;

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

Line 1718: l_permanent_country per_addresses.country%type;

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);