APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PQP_ANALYZED_ALIEN_DETAILS

Line 3131: pqp_analyzed_alien_details.analyzed_data_details_id%type;

3127: l_effective_date date ; -- Added by tmehra Oct02
3128: l_date_of_birth date ;
3129: l_sit_flag boolean ;
3130: l_analyzed_data_details_id
3131: pqp_analyzed_alien_details.analyzed_data_details_id%type;
3132: l_analyzed_data_id pqp_analyzed_alien_data.analyzed_data_id%type ;
3133: l_exemption_code pqp_analyzed_alien_details.exemption_code%type;
3134: l_withholding_rate
3135: pqp_analyzed_alien_details.withholding_rate%type ;

Line 3133: l_exemption_code pqp_analyzed_alien_details.exemption_code%type;

3129: l_sit_flag boolean ;
3130: l_analyzed_data_details_id
3131: pqp_analyzed_alien_details.analyzed_data_details_id%type;
3132: l_analyzed_data_id pqp_analyzed_alien_data.analyzed_data_id%type ;
3133: l_exemption_code pqp_analyzed_alien_details.exemption_code%type;
3134: l_withholding_rate
3135: pqp_analyzed_alien_details.withholding_rate%type ;
3136: l_wh_allowance
3137: pqp_analyzed_alien_data.withldg_allow_eligible_flag%type;

Line 3135: pqp_analyzed_alien_details.withholding_rate%type ;

3131: pqp_analyzed_alien_details.analyzed_data_details_id%type;
3132: l_analyzed_data_id pqp_analyzed_alien_data.analyzed_data_id%type ;
3133: l_exemption_code pqp_analyzed_alien_details.exemption_code%type;
3134: l_withholding_rate
3135: pqp_analyzed_alien_details.withholding_rate%type ;
3136: l_wh_allowance
3137: pqp_analyzed_alien_data.withldg_allow_eligible_flag%type;
3138: l_income_code_sub_type
3139: pqp_analyzed_alien_details.income_code_sub_type%type ;

Line 3139: pqp_analyzed_alien_details.income_code_sub_type%type ;

3135: pqp_analyzed_alien_details.withholding_rate%type ;
3136: l_wh_allowance
3137: pqp_analyzed_alien_data.withldg_allow_eligible_flag%type;
3138: l_income_code_sub_type
3139: pqp_analyzed_alien_details.income_code_sub_type%type ;
3140: l_constant_addl_tax pqp_analyzed_alien_details.constant_addl_tax%type ;
3141:
3142:
3143: type t_temp_person_assgn_rec is record

Line 3140: l_constant_addl_tax pqp_analyzed_alien_details.constant_addl_tax%type ;

3136: l_wh_allowance
3137: pqp_analyzed_alien_data.withldg_allow_eligible_flag%type;
3138: l_income_code_sub_type
3139: pqp_analyzed_alien_details.income_code_sub_type%type ;
3140: l_constant_addl_tax pqp_analyzed_alien_details.constant_addl_tax%type ;
3141:
3142:
3143: type t_temp_person_assgn_rec is record
3144: (

Line 3158: pqp_analyzed_alien_details table for the given income code and given

3154: t_lookup_table t_lookup_table_type ;
3155:
3156: /*****
3157: the following cursor decides whether a row is present in the
3158: pqp_analyzed_alien_details table for the given income code and given
3159: assignment id
3160: *****/
3161:
3162: cursor c_analyzed_data(p_income_code in varchar2 ,

Line 3171: pqp_analyzed_alien_details paadet ,

3167: withholding_rate ,
3168: income_code_sub_type ,
3169: constant_addl_tax
3170: from pqp_analyzed_alien_data paadat ,
3171: pqp_analyzed_alien_details paadet ,
3172: per_people_f ppf ,
3173: per_assignments_f paf
3174: where paadat.analyzed_data_id = paadet.analyzed_data_id
3175: and paadet.income_code = p_income_code

Line 4723: PQP_ANALYZED_ALIEN_DETAILS, and PQP_ANALYZED_ALIEN_DATA tables.

4719:
4720: /****************************************************************************
4721: name : pqp_write_public
4722: Purpose : the procedure write data into PQP_ANALYZED_ALIEN_DATA,
4723: PQP_ANALYZED_ALIEN_DETAILS, and PQP_ANALYZED_ALIEN_DATA tables.
4724: Arguments :
4725: in
4726: Notes : public
4727: ****************************************************************************/

Line 4918: -- pqp_analyzed_alien_details table for a given analyzed_data_id. The

4914: where assignment_id = p_assignment_id
4915: and tax_year = p_tax_year;
4916: --
4917: -- The following cursor verifies whether an income_code exists in
4918: -- pqp_analyzed_alien_details table for a given analyzed_data_id. The
4919: -- assumption is that a single row will be present for an income code
4920: -- for an analyzed_data_id at a point in time.
4921: --
4922: cursor c_analyzed_det_exists(p_analyzed_data_id in number

Line 4928: from pqp_analyzed_alien_details

4924: select analyzed_data_details_id
4925: ,object_version_number
4926: ,retro_lose_ben_amt_flag
4927: ,retro_lose_ben_date_flag
4928: from pqp_analyzed_alien_details
4929: where analyzed_data_id = p_analyzed_data_id
4930: and income_code = p_income_code;
4931: --
4932: -- Converts Oracle Pay periods to Windstar Pay periods

Line 5883: from pqp_analyzed_alien_details

5879:
5880: begin
5881: select retro_loss_notification_sent
5882: into l_notification_sent
5883: from pqp_analyzed_alien_details
5884: where analyzed_data_details_id = l_analyzed_data_details_id
5885: and analyzed_data_id = l_analyzed_data_id;
5886: exception
5887: when NO_DATA_FOUND then