APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PQP_ALIEN_TRANSACTION_DATA

Line 4792: l_retro_lose_ben_amt_mesg pqp_alien_transaction_data.ERROR_TEXT%type;

4788: ,p_error_message out nocopy varchar2
4789: ) is
4790:
4791: t_balance_tab pqp_alien_expat_taxation_pkg.t_balance_tab_type;
4792: l_retro_lose_ben_amt_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4793: l_retro_lose_ben_date_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4794: l_income_code_change_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4795: l_current_analysis_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4796:

Line 4793: l_retro_lose_ben_date_mesg pqp_alien_transaction_data.ERROR_TEXT%type;

4789: ) is
4790:
4791: t_balance_tab pqp_alien_expat_taxation_pkg.t_balance_tab_type;
4792: l_retro_lose_ben_amt_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4793: l_retro_lose_ben_date_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4794: l_income_code_change_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4795: l_current_analysis_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4796:
4797: l_windstar_yes number := -1;

Line 4794: l_income_code_change_mesg pqp_alien_transaction_data.ERROR_TEXT%type;

4790:
4791: t_balance_tab pqp_alien_expat_taxation_pkg.t_balance_tab_type;
4792: l_retro_lose_ben_amt_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4793: l_retro_lose_ben_date_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4794: l_income_code_change_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4795: l_current_analysis_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4796:
4797: l_windstar_yes number := -1;
4798: l_windstar_no number := 0;

Line 4795: l_current_analysis_mesg pqp_alien_transaction_data.ERROR_TEXT%type;

4791: t_balance_tab pqp_alien_expat_taxation_pkg.t_balance_tab_type;
4792: l_retro_lose_ben_amt_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4793: l_retro_lose_ben_date_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4794: l_income_code_change_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4795: l_current_analysis_mesg pqp_alien_transaction_data.ERROR_TEXT%type;
4796:
4797: l_windstar_yes number := -1;
4798: l_windstar_no number := 0;
4799: l_alien_transaction_id number;

Line 4942: -- PQP_ALIEN_TRANSACTION_DATA table

4938: where lookup_type = 'PQP_US_WIND_ORA_PERIODS'
4939: and lookup_code = p_lookup_code ;
4940: --
4941: -- The following cursor selects OVN and PK from
4942: -- PQP_ALIEN_TRANSACTION_DATA table
4943: --
4944: cursor c_atd(p_alien_transaction_id in number) is
4945: select object_version_number
4946: from pqp_alien_transaction_data

Line 4946: from pqp_alien_transaction_data

4942: -- PQP_ALIEN_TRANSACTION_DATA table
4943: --
4944: cursor c_atd(p_alien_transaction_id in number) is
4945: select object_version_number
4946: from pqp_alien_transaction_data
4947: where alien_transaction_id = p_alien_transaction_id;
4948: --
4949: -- The following cursor finds the effective end date for a Person.
4950: --

Line 4986: -- PQP_ALIEN_TRANSACTION_DATA table

4982: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY'));
4983:
4984: --
4985: -- The following cursor fetches the latest transaction from
4986: -- PQP_ALIEN_TRANSACTION_DATA table
4987: --
4988: cursor c_get_per_trans(c_person_id number) is
4989: select patd.date_w4_signed
4990: ,patd.personal_exemption

Line 4995: from pqp_alien_transaction_data patd

4991: ,patd.addl_exemption_allowed
4992: ,patd.addl_withholding_amt
4993: ,patd.constant_addl_tax
4994: ,patd.current_residency_status
4995: from pqp_alien_transaction_data patd
4996: where person_id = c_person_id
4997: and alien_transaction_id =
4998: (select MAX(patd1.alien_transaction_id)
4999: from PQP_ALIEN_TRANSACTION_DATA patd1

Line 4999: from PQP_ALIEN_TRANSACTION_DATA patd1

4995: from pqp_alien_transaction_data patd
4996: where person_id = c_person_id
4997: and alien_transaction_id =
4998: (select MAX(patd1.alien_transaction_id)
4999: from PQP_ALIEN_TRANSACTION_DATA patd1
5000: where patd.person_id=patd1.person_id
5001: having tax_year =max(tax_year)
5002: group by tax_year);
5003:

Line 5307: l_logic_state := ' while inserting in PQP_ALIEN_TRANSACTION_DATA : ';

5303: end if;
5304: --
5305: -- Inserting into Alien_transaction_data table
5306: --
5307: l_logic_state := ' while inserting in PQP_ALIEN_TRANSACTION_DATA : ';
5308:
5309: pqp_alien_trans_data_api.create_alien_trans_data
5310: (p_validate => false
5311: ,p_alien_transaction_id => l_alien_transaction_id

Line 5378: -- PQP_ALIEN_TRANSACTION_DATA table.

5374: -- A W4 record will be created under the following conditions.
5375: -- 1. no data is present in the PQP_ANALYZED_ALIEN_DATA (This happens
5376: -- for the first time only),
5377: -- 2. date_w4_signed field is not null in the
5378: -- PQP_ALIEN_TRANSACTION_DATA table.
5379: -- 3. Either of the following values is present
5380: -- a. personal_exemption is present
5381: -- b. addl_exemption_allowed
5382: -- c. addl_withholding_amt