DBA Data[Home] [Help]

APPS.PQP_PTY_DEL dependencies on PQP_PTY_SHD

Line 54: (p_rec in out nocopy pqp_pty_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pqp_pty_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 137: (p_rec in out nocopy pqp_pty_shd.g_rec_type

133: -- ----------------------------------------------------------------------------
134: -- |------------------------------< delete_dml >------------------------------|
135: -- ----------------------------------------------------------------------------
136: Procedure delete_dml
137: (p_rec in out nocopy pqp_pty_shd.g_rec_type
138: ,p_effective_date in date
139: ,p_datetrack_mode in varchar2
140: ,p_validation_start_date in date
141: ,p_validation_end_date in date

Line 194: (p_rec in out nocopy pqp_pty_shd.g_rec_type

190: --
191: -- {End Of Comments}
192: -- ----------------------------------------------------------------------------
193: Procedure dt_pre_delete
194: (p_rec in out nocopy pqp_pty_shd.g_rec_type
195: ,p_effective_date in date
196: ,p_datetrack_mode in varchar2
197: ,p_validation_start_date in date
198: ,p_validation_end_date in date

Line 209: := pqp_pty_shd.g_old_rec.effective_start_date;

205: --
206: If (p_datetrack_mode <> hr_api.g_zap) then
207: --
208: p_rec.effective_start_date
209: := pqp_pty_shd.g_old_rec.effective_start_date;
210: --
211: If (p_datetrack_mode = hr_api.g_delete) then
212: p_rec.effective_end_date := p_validation_start_date - 1;
213: Else

Line 219: pqp_pty_shd.upd_effective_end_date

215: End If;
216: --
217: -- Update the current effective end date record
218: --
219: pqp_pty_shd.upd_effective_end_date
220: (p_effective_date => p_effective_date
221: ,p_base_key_value => p_rec.pension_type_id
222: ,p_new_effective_end_date => p_rec.effective_end_date
223: ,p_validation_start_date => p_validation_start_date

Line 268: (p_rec in out nocopy pqp_pty_shd.g_rec_type

264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure pre_delete
268: (p_rec in out nocopy pqp_pty_shd.g_rec_type
269: ,p_effective_date in date
270: ,p_datetrack_mode in varchar2
271: ,p_validation_start_date in date
272: ,p_validation_end_date in date

Line 328: (p_rec in pqp_pty_shd.g_rec_type

324: --
325: -- {End Of Comments}
326: -- ----------------------------------------------------------------------------
327: Procedure post_delete
328: (p_rec in pqp_pty_shd.g_rec_type
329: ,p_effective_date in date
330: ,p_datetrack_mode in varchar2
331: ,p_validation_start_date in date
332: ,p_validation_end_date in date

Line 363: => pqp_pty_shd.g_old_rec.effective_start_date

359: => p_rec.effective_start_date
360: ,p_effective_end_date
361: => p_rec.effective_end_date
362: ,p_effective_start_date_o
363: => pqp_pty_shd.g_old_rec.effective_start_date
364: ,p_effective_end_date_o
365: => pqp_pty_shd.g_old_rec.effective_end_date
366: ,p_pension_type_name_o
367: => pqp_pty_shd.g_old_rec.pension_type_name

Line 365: => pqp_pty_shd.g_old_rec.effective_end_date

361: => p_rec.effective_end_date
362: ,p_effective_start_date_o
363: => pqp_pty_shd.g_old_rec.effective_start_date
364: ,p_effective_end_date_o
365: => pqp_pty_shd.g_old_rec.effective_end_date
366: ,p_pension_type_name_o
367: => pqp_pty_shd.g_old_rec.pension_type_name
368: ,p_pension_category_o
369: => pqp_pty_shd.g_old_rec.pension_category

Line 367: => pqp_pty_shd.g_old_rec.pension_type_name

363: => pqp_pty_shd.g_old_rec.effective_start_date
364: ,p_effective_end_date_o
365: => pqp_pty_shd.g_old_rec.effective_end_date
366: ,p_pension_type_name_o
367: => pqp_pty_shd.g_old_rec.pension_type_name
368: ,p_pension_category_o
369: => pqp_pty_shd.g_old_rec.pension_category
370: ,p_pension_provider_type_o
371: => pqp_pty_shd.g_old_rec.pension_provider_type

Line 369: => pqp_pty_shd.g_old_rec.pension_category

365: => pqp_pty_shd.g_old_rec.effective_end_date
366: ,p_pension_type_name_o
367: => pqp_pty_shd.g_old_rec.pension_type_name
368: ,p_pension_category_o
369: => pqp_pty_shd.g_old_rec.pension_category
370: ,p_pension_provider_type_o
371: => pqp_pty_shd.g_old_rec.pension_provider_type
372: ,p_salary_calculation_method_o
373: => pqp_pty_shd.g_old_rec.salary_calculation_method

Line 371: => pqp_pty_shd.g_old_rec.pension_provider_type

367: => pqp_pty_shd.g_old_rec.pension_type_name
368: ,p_pension_category_o
369: => pqp_pty_shd.g_old_rec.pension_category
370: ,p_pension_provider_type_o
371: => pqp_pty_shd.g_old_rec.pension_provider_type
372: ,p_salary_calculation_method_o
373: => pqp_pty_shd.g_old_rec.salary_calculation_method
374: ,p_threshold_conversion_rule_o
375: => pqp_pty_shd.g_old_rec.threshold_conversion_rule

Line 373: => pqp_pty_shd.g_old_rec.salary_calculation_method

369: => pqp_pty_shd.g_old_rec.pension_category
370: ,p_pension_provider_type_o
371: => pqp_pty_shd.g_old_rec.pension_provider_type
372: ,p_salary_calculation_method_o
373: => pqp_pty_shd.g_old_rec.salary_calculation_method
374: ,p_threshold_conversion_rule_o
375: => pqp_pty_shd.g_old_rec.threshold_conversion_rule
376: ,p_contribution_conversion_ru_o
377: => pqp_pty_shd.g_old_rec.contribution_conversion_rule

Line 375: => pqp_pty_shd.g_old_rec.threshold_conversion_rule

371: => pqp_pty_shd.g_old_rec.pension_provider_type
372: ,p_salary_calculation_method_o
373: => pqp_pty_shd.g_old_rec.salary_calculation_method
374: ,p_threshold_conversion_rule_o
375: => pqp_pty_shd.g_old_rec.threshold_conversion_rule
376: ,p_contribution_conversion_ru_o
377: => pqp_pty_shd.g_old_rec.contribution_conversion_rule
378: ,p_er_annual_limit_o
379: => pqp_pty_shd.g_old_rec.er_annual_limit

Line 377: => pqp_pty_shd.g_old_rec.contribution_conversion_rule

373: => pqp_pty_shd.g_old_rec.salary_calculation_method
374: ,p_threshold_conversion_rule_o
375: => pqp_pty_shd.g_old_rec.threshold_conversion_rule
376: ,p_contribution_conversion_ru_o
377: => pqp_pty_shd.g_old_rec.contribution_conversion_rule
378: ,p_er_annual_limit_o
379: => pqp_pty_shd.g_old_rec.er_annual_limit
380: ,p_ee_annual_limit_o
381: => pqp_pty_shd.g_old_rec.ee_annual_limit

Line 379: => pqp_pty_shd.g_old_rec.er_annual_limit

375: => pqp_pty_shd.g_old_rec.threshold_conversion_rule
376: ,p_contribution_conversion_ru_o
377: => pqp_pty_shd.g_old_rec.contribution_conversion_rule
378: ,p_er_annual_limit_o
379: => pqp_pty_shd.g_old_rec.er_annual_limit
380: ,p_ee_annual_limit_o
381: => pqp_pty_shd.g_old_rec.ee_annual_limit
382: ,p_er_annual_salary_threshold_o
383: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold

Line 381: => pqp_pty_shd.g_old_rec.ee_annual_limit

377: => pqp_pty_shd.g_old_rec.contribution_conversion_rule
378: ,p_er_annual_limit_o
379: => pqp_pty_shd.g_old_rec.er_annual_limit
380: ,p_ee_annual_limit_o
381: => pqp_pty_shd.g_old_rec.ee_annual_limit
382: ,p_er_annual_salary_threshold_o
383: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
384: ,p_ee_annual_salary_threshold_o
385: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold

Line 383: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold

379: => pqp_pty_shd.g_old_rec.er_annual_limit
380: ,p_ee_annual_limit_o
381: => pqp_pty_shd.g_old_rec.ee_annual_limit
382: ,p_er_annual_salary_threshold_o
383: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
384: ,p_ee_annual_salary_threshold_o
385: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
386: ,p_object_version_number_o
387: => pqp_pty_shd.g_old_rec.object_version_number

Line 385: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold

381: => pqp_pty_shd.g_old_rec.ee_annual_limit
382: ,p_er_annual_salary_threshold_o
383: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
384: ,p_ee_annual_salary_threshold_o
385: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
386: ,p_object_version_number_o
387: => pqp_pty_shd.g_old_rec.object_version_number
388: ,p_business_group_id_o
389: => pqp_pty_shd.g_old_rec.business_group_id

Line 387: => pqp_pty_shd.g_old_rec.object_version_number

383: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
384: ,p_ee_annual_salary_threshold_o
385: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
386: ,p_object_version_number_o
387: => pqp_pty_shd.g_old_rec.object_version_number
388: ,p_business_group_id_o
389: => pqp_pty_shd.g_old_rec.business_group_id
390: ,p_legislation_code_o
391: => pqp_pty_shd.g_old_rec.legislation_code

Line 389: => pqp_pty_shd.g_old_rec.business_group_id

385: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
386: ,p_object_version_number_o
387: => pqp_pty_shd.g_old_rec.object_version_number
388: ,p_business_group_id_o
389: => pqp_pty_shd.g_old_rec.business_group_id
390: ,p_legislation_code_o
391: => pqp_pty_shd.g_old_rec.legislation_code
392: ,p_description_o
393: => pqp_pty_shd.g_old_rec.description

Line 391: => pqp_pty_shd.g_old_rec.legislation_code

387: => pqp_pty_shd.g_old_rec.object_version_number
388: ,p_business_group_id_o
389: => pqp_pty_shd.g_old_rec.business_group_id
390: ,p_legislation_code_o
391: => pqp_pty_shd.g_old_rec.legislation_code
392: ,p_description_o
393: => pqp_pty_shd.g_old_rec.description
394: ,p_minimum_age_o
395: => pqp_pty_shd.g_old_rec.minimum_age

Line 393: => pqp_pty_shd.g_old_rec.description

389: => pqp_pty_shd.g_old_rec.business_group_id
390: ,p_legislation_code_o
391: => pqp_pty_shd.g_old_rec.legislation_code
392: ,p_description_o
393: => pqp_pty_shd.g_old_rec.description
394: ,p_minimum_age_o
395: => pqp_pty_shd.g_old_rec.minimum_age
396: ,p_ee_contribution_percent_o
397: => pqp_pty_shd.g_old_rec.ee_contribution_percent

Line 395: => pqp_pty_shd.g_old_rec.minimum_age

391: => pqp_pty_shd.g_old_rec.legislation_code
392: ,p_description_o
393: => pqp_pty_shd.g_old_rec.description
394: ,p_minimum_age_o
395: => pqp_pty_shd.g_old_rec.minimum_age
396: ,p_ee_contribution_percent_o
397: => pqp_pty_shd.g_old_rec.ee_contribution_percent
398: ,p_maximum_age_o
399: => pqp_pty_shd.g_old_rec.maximum_age

Line 397: => pqp_pty_shd.g_old_rec.ee_contribution_percent

393: => pqp_pty_shd.g_old_rec.description
394: ,p_minimum_age_o
395: => pqp_pty_shd.g_old_rec.minimum_age
396: ,p_ee_contribution_percent_o
397: => pqp_pty_shd.g_old_rec.ee_contribution_percent
398: ,p_maximum_age_o
399: => pqp_pty_shd.g_old_rec.maximum_age
400: ,p_er_contribution_percent_o
401: => pqp_pty_shd.g_old_rec.er_contribution_percent

Line 399: => pqp_pty_shd.g_old_rec.maximum_age

395: => pqp_pty_shd.g_old_rec.minimum_age
396: ,p_ee_contribution_percent_o
397: => pqp_pty_shd.g_old_rec.ee_contribution_percent
398: ,p_maximum_age_o
399: => pqp_pty_shd.g_old_rec.maximum_age
400: ,p_er_contribution_percent_o
401: => pqp_pty_shd.g_old_rec.er_contribution_percent
402: ,p_ee_annual_contribution_o
403: => pqp_pty_shd.g_old_rec.ee_annual_contribution

Line 401: => pqp_pty_shd.g_old_rec.er_contribution_percent

397: => pqp_pty_shd.g_old_rec.ee_contribution_percent
398: ,p_maximum_age_o
399: => pqp_pty_shd.g_old_rec.maximum_age
400: ,p_er_contribution_percent_o
401: => pqp_pty_shd.g_old_rec.er_contribution_percent
402: ,p_ee_annual_contribution_o
403: => pqp_pty_shd.g_old_rec.ee_annual_contribution
404: ,p_er_annual_contribution_o
405: => pqp_pty_shd.g_old_rec.er_annual_contribution

Line 403: => pqp_pty_shd.g_old_rec.ee_annual_contribution

399: => pqp_pty_shd.g_old_rec.maximum_age
400: ,p_er_contribution_percent_o
401: => pqp_pty_shd.g_old_rec.er_contribution_percent
402: ,p_ee_annual_contribution_o
403: => pqp_pty_shd.g_old_rec.ee_annual_contribution
404: ,p_er_annual_contribution_o
405: => pqp_pty_shd.g_old_rec.er_annual_contribution
406: ,p_annual_premium_amount_o
407: => pqp_pty_shd.g_old_rec.annual_premium_amount

Line 405: => pqp_pty_shd.g_old_rec.er_annual_contribution

401: => pqp_pty_shd.g_old_rec.er_contribution_percent
402: ,p_ee_annual_contribution_o
403: => pqp_pty_shd.g_old_rec.ee_annual_contribution
404: ,p_er_annual_contribution_o
405: => pqp_pty_shd.g_old_rec.er_annual_contribution
406: ,p_annual_premium_amount_o
407: => pqp_pty_shd.g_old_rec.annual_premium_amount
408: ,p_ee_contribution_bal_type_i_o
409: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id

Line 407: => pqp_pty_shd.g_old_rec.annual_premium_amount

403: => pqp_pty_shd.g_old_rec.ee_annual_contribution
404: ,p_er_annual_contribution_o
405: => pqp_pty_shd.g_old_rec.er_annual_contribution
406: ,p_annual_premium_amount_o
407: => pqp_pty_shd.g_old_rec.annual_premium_amount
408: ,p_ee_contribution_bal_type_i_o
409: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
410: ,p_er_contribution_bal_type_i_o
411: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id

Line 409: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id

405: => pqp_pty_shd.g_old_rec.er_annual_contribution
406: ,p_annual_premium_amount_o
407: => pqp_pty_shd.g_old_rec.annual_premium_amount
408: ,p_ee_contribution_bal_type_i_o
409: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
410: ,p_er_contribution_bal_type_i_o
411: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
412: ,p_balance_init_element_type__o
413: => pqp_pty_shd.g_old_rec.balance_init_element_type_id

Line 411: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id

407: => pqp_pty_shd.g_old_rec.annual_premium_amount
408: ,p_ee_contribution_bal_type_i_o
409: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
410: ,p_er_contribution_bal_type_i_o
411: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
412: ,p_balance_init_element_type__o
413: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
414: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
415: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate

Line 413: => pqp_pty_shd.g_old_rec.balance_init_element_type_id

409: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
410: ,p_er_contribution_bal_type_i_o
411: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
412: ,p_balance_init_element_type__o
413: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
414: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
415: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
416: ,p_pty_attribute_category_o
417: => pqp_pty_shd.g_old_rec.pty_attribute_category

Line 414: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate

410: ,p_er_contribution_bal_type_i_o
411: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
412: ,p_balance_init_element_type__o
413: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
414: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
415: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
416: ,p_pty_attribute_category_o
417: => pqp_pty_shd.g_old_rec.pty_attribute_category
418: ,p_pty_attribute1_o

Line 415: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate

411: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
412: ,p_balance_init_element_type__o
413: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
414: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
415: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
416: ,p_pty_attribute_category_o
417: => pqp_pty_shd.g_old_rec.pty_attribute_category
418: ,p_pty_attribute1_o
419: => pqp_pty_shd.g_old_rec.pty_attribute1

Line 417: => pqp_pty_shd.g_old_rec.pty_attribute_category

413: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
414: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
415: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
416: ,p_pty_attribute_category_o
417: => pqp_pty_shd.g_old_rec.pty_attribute_category
418: ,p_pty_attribute1_o
419: => pqp_pty_shd.g_old_rec.pty_attribute1
420: ,p_pty_attribute2_o
421: => pqp_pty_shd.g_old_rec.pty_attribute2

Line 419: => pqp_pty_shd.g_old_rec.pty_attribute1

415: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
416: ,p_pty_attribute_category_o
417: => pqp_pty_shd.g_old_rec.pty_attribute_category
418: ,p_pty_attribute1_o
419: => pqp_pty_shd.g_old_rec.pty_attribute1
420: ,p_pty_attribute2_o
421: => pqp_pty_shd.g_old_rec.pty_attribute2
422: ,p_pty_attribute3_o
423: => pqp_pty_shd.g_old_rec.pty_attribute3

Line 421: => pqp_pty_shd.g_old_rec.pty_attribute2

417: => pqp_pty_shd.g_old_rec.pty_attribute_category
418: ,p_pty_attribute1_o
419: => pqp_pty_shd.g_old_rec.pty_attribute1
420: ,p_pty_attribute2_o
421: => pqp_pty_shd.g_old_rec.pty_attribute2
422: ,p_pty_attribute3_o
423: => pqp_pty_shd.g_old_rec.pty_attribute3
424: ,p_pty_attribute4_o
425: => pqp_pty_shd.g_old_rec.pty_attribute4

Line 423: => pqp_pty_shd.g_old_rec.pty_attribute3

419: => pqp_pty_shd.g_old_rec.pty_attribute1
420: ,p_pty_attribute2_o
421: => pqp_pty_shd.g_old_rec.pty_attribute2
422: ,p_pty_attribute3_o
423: => pqp_pty_shd.g_old_rec.pty_attribute3
424: ,p_pty_attribute4_o
425: => pqp_pty_shd.g_old_rec.pty_attribute4
426: ,p_pty_attribute5_o
427: => pqp_pty_shd.g_old_rec.pty_attribute5

Line 425: => pqp_pty_shd.g_old_rec.pty_attribute4

421: => pqp_pty_shd.g_old_rec.pty_attribute2
422: ,p_pty_attribute3_o
423: => pqp_pty_shd.g_old_rec.pty_attribute3
424: ,p_pty_attribute4_o
425: => pqp_pty_shd.g_old_rec.pty_attribute4
426: ,p_pty_attribute5_o
427: => pqp_pty_shd.g_old_rec.pty_attribute5
428: ,p_pty_attribute6_o
429: => pqp_pty_shd.g_old_rec.pty_attribute6

Line 427: => pqp_pty_shd.g_old_rec.pty_attribute5

423: => pqp_pty_shd.g_old_rec.pty_attribute3
424: ,p_pty_attribute4_o
425: => pqp_pty_shd.g_old_rec.pty_attribute4
426: ,p_pty_attribute5_o
427: => pqp_pty_shd.g_old_rec.pty_attribute5
428: ,p_pty_attribute6_o
429: => pqp_pty_shd.g_old_rec.pty_attribute6
430: ,p_pty_attribute7_o
431: => pqp_pty_shd.g_old_rec.pty_attribute7

Line 429: => pqp_pty_shd.g_old_rec.pty_attribute6

425: => pqp_pty_shd.g_old_rec.pty_attribute4
426: ,p_pty_attribute5_o
427: => pqp_pty_shd.g_old_rec.pty_attribute5
428: ,p_pty_attribute6_o
429: => pqp_pty_shd.g_old_rec.pty_attribute6
430: ,p_pty_attribute7_o
431: => pqp_pty_shd.g_old_rec.pty_attribute7
432: ,p_pty_attribute8_o
433: => pqp_pty_shd.g_old_rec.pty_attribute8

Line 431: => pqp_pty_shd.g_old_rec.pty_attribute7

427: => pqp_pty_shd.g_old_rec.pty_attribute5
428: ,p_pty_attribute6_o
429: => pqp_pty_shd.g_old_rec.pty_attribute6
430: ,p_pty_attribute7_o
431: => pqp_pty_shd.g_old_rec.pty_attribute7
432: ,p_pty_attribute8_o
433: => pqp_pty_shd.g_old_rec.pty_attribute8
434: ,p_pty_attribute9_o
435: => pqp_pty_shd.g_old_rec.pty_attribute9

Line 433: => pqp_pty_shd.g_old_rec.pty_attribute8

429: => pqp_pty_shd.g_old_rec.pty_attribute6
430: ,p_pty_attribute7_o
431: => pqp_pty_shd.g_old_rec.pty_attribute7
432: ,p_pty_attribute8_o
433: => pqp_pty_shd.g_old_rec.pty_attribute8
434: ,p_pty_attribute9_o
435: => pqp_pty_shd.g_old_rec.pty_attribute9
436: ,p_pty_attribute10_o
437: => pqp_pty_shd.g_old_rec.pty_attribute10

Line 435: => pqp_pty_shd.g_old_rec.pty_attribute9

431: => pqp_pty_shd.g_old_rec.pty_attribute7
432: ,p_pty_attribute8_o
433: => pqp_pty_shd.g_old_rec.pty_attribute8
434: ,p_pty_attribute9_o
435: => pqp_pty_shd.g_old_rec.pty_attribute9
436: ,p_pty_attribute10_o
437: => pqp_pty_shd.g_old_rec.pty_attribute10
438: ,p_pty_attribute11_o
439: => pqp_pty_shd.g_old_rec.pty_attribute11

Line 437: => pqp_pty_shd.g_old_rec.pty_attribute10

433: => pqp_pty_shd.g_old_rec.pty_attribute8
434: ,p_pty_attribute9_o
435: => pqp_pty_shd.g_old_rec.pty_attribute9
436: ,p_pty_attribute10_o
437: => pqp_pty_shd.g_old_rec.pty_attribute10
438: ,p_pty_attribute11_o
439: => pqp_pty_shd.g_old_rec.pty_attribute11
440: ,p_pty_attribute12_o
441: => pqp_pty_shd.g_old_rec.pty_attribute12

Line 439: => pqp_pty_shd.g_old_rec.pty_attribute11

435: => pqp_pty_shd.g_old_rec.pty_attribute9
436: ,p_pty_attribute10_o
437: => pqp_pty_shd.g_old_rec.pty_attribute10
438: ,p_pty_attribute11_o
439: => pqp_pty_shd.g_old_rec.pty_attribute11
440: ,p_pty_attribute12_o
441: => pqp_pty_shd.g_old_rec.pty_attribute12
442: ,p_pty_attribute13_o
443: => pqp_pty_shd.g_old_rec.pty_attribute13

Line 441: => pqp_pty_shd.g_old_rec.pty_attribute12

437: => pqp_pty_shd.g_old_rec.pty_attribute10
438: ,p_pty_attribute11_o
439: => pqp_pty_shd.g_old_rec.pty_attribute11
440: ,p_pty_attribute12_o
441: => pqp_pty_shd.g_old_rec.pty_attribute12
442: ,p_pty_attribute13_o
443: => pqp_pty_shd.g_old_rec.pty_attribute13
444: ,p_pty_attribute14_o
445: => pqp_pty_shd.g_old_rec.pty_attribute14

Line 443: => pqp_pty_shd.g_old_rec.pty_attribute13

439: => pqp_pty_shd.g_old_rec.pty_attribute11
440: ,p_pty_attribute12_o
441: => pqp_pty_shd.g_old_rec.pty_attribute12
442: ,p_pty_attribute13_o
443: => pqp_pty_shd.g_old_rec.pty_attribute13
444: ,p_pty_attribute14_o
445: => pqp_pty_shd.g_old_rec.pty_attribute14
446: ,p_pty_attribute15_o
447: => pqp_pty_shd.g_old_rec.pty_attribute15

Line 445: => pqp_pty_shd.g_old_rec.pty_attribute14

441: => pqp_pty_shd.g_old_rec.pty_attribute12
442: ,p_pty_attribute13_o
443: => pqp_pty_shd.g_old_rec.pty_attribute13
444: ,p_pty_attribute14_o
445: => pqp_pty_shd.g_old_rec.pty_attribute14
446: ,p_pty_attribute15_o
447: => pqp_pty_shd.g_old_rec.pty_attribute15
448: ,p_pty_attribute16_o
449: => pqp_pty_shd.g_old_rec.pty_attribute16

Line 447: => pqp_pty_shd.g_old_rec.pty_attribute15

443: => pqp_pty_shd.g_old_rec.pty_attribute13
444: ,p_pty_attribute14_o
445: => pqp_pty_shd.g_old_rec.pty_attribute14
446: ,p_pty_attribute15_o
447: => pqp_pty_shd.g_old_rec.pty_attribute15
448: ,p_pty_attribute16_o
449: => pqp_pty_shd.g_old_rec.pty_attribute16
450: ,p_pty_attribute17_o
451: => pqp_pty_shd.g_old_rec.pty_attribute17

Line 449: => pqp_pty_shd.g_old_rec.pty_attribute16

445: => pqp_pty_shd.g_old_rec.pty_attribute14
446: ,p_pty_attribute15_o
447: => pqp_pty_shd.g_old_rec.pty_attribute15
448: ,p_pty_attribute16_o
449: => pqp_pty_shd.g_old_rec.pty_attribute16
450: ,p_pty_attribute17_o
451: => pqp_pty_shd.g_old_rec.pty_attribute17
452: ,p_pty_attribute18_o
453: => pqp_pty_shd.g_old_rec.pty_attribute18

Line 451: => pqp_pty_shd.g_old_rec.pty_attribute17

447: => pqp_pty_shd.g_old_rec.pty_attribute15
448: ,p_pty_attribute16_o
449: => pqp_pty_shd.g_old_rec.pty_attribute16
450: ,p_pty_attribute17_o
451: => pqp_pty_shd.g_old_rec.pty_attribute17
452: ,p_pty_attribute18_o
453: => pqp_pty_shd.g_old_rec.pty_attribute18
454: ,p_pty_attribute19_o
455: => pqp_pty_shd.g_old_rec.pty_attribute19

Line 453: => pqp_pty_shd.g_old_rec.pty_attribute18

449: => pqp_pty_shd.g_old_rec.pty_attribute16
450: ,p_pty_attribute17_o
451: => pqp_pty_shd.g_old_rec.pty_attribute17
452: ,p_pty_attribute18_o
453: => pqp_pty_shd.g_old_rec.pty_attribute18
454: ,p_pty_attribute19_o
455: => pqp_pty_shd.g_old_rec.pty_attribute19
456: ,p_pty_attribute20_o
457: => pqp_pty_shd.g_old_rec.pty_attribute20

Line 455: => pqp_pty_shd.g_old_rec.pty_attribute19

451: => pqp_pty_shd.g_old_rec.pty_attribute17
452: ,p_pty_attribute18_o
453: => pqp_pty_shd.g_old_rec.pty_attribute18
454: ,p_pty_attribute19_o
455: => pqp_pty_shd.g_old_rec.pty_attribute19
456: ,p_pty_attribute20_o
457: => pqp_pty_shd.g_old_rec.pty_attribute20
458: ,p_pty_information_category_o
459: => pqp_pty_shd.g_old_rec.pty_information_category

Line 457: => pqp_pty_shd.g_old_rec.pty_attribute20

453: => pqp_pty_shd.g_old_rec.pty_attribute18
454: ,p_pty_attribute19_o
455: => pqp_pty_shd.g_old_rec.pty_attribute19
456: ,p_pty_attribute20_o
457: => pqp_pty_shd.g_old_rec.pty_attribute20
458: ,p_pty_information_category_o
459: => pqp_pty_shd.g_old_rec.pty_information_category
460: ,p_pty_information1_o
461: => pqp_pty_shd.g_old_rec.pty_information1

Line 459: => pqp_pty_shd.g_old_rec.pty_information_category

455: => pqp_pty_shd.g_old_rec.pty_attribute19
456: ,p_pty_attribute20_o
457: => pqp_pty_shd.g_old_rec.pty_attribute20
458: ,p_pty_information_category_o
459: => pqp_pty_shd.g_old_rec.pty_information_category
460: ,p_pty_information1_o
461: => pqp_pty_shd.g_old_rec.pty_information1
462: ,p_pty_information2_o
463: => pqp_pty_shd.g_old_rec.pty_information2

Line 461: => pqp_pty_shd.g_old_rec.pty_information1

457: => pqp_pty_shd.g_old_rec.pty_attribute20
458: ,p_pty_information_category_o
459: => pqp_pty_shd.g_old_rec.pty_information_category
460: ,p_pty_information1_o
461: => pqp_pty_shd.g_old_rec.pty_information1
462: ,p_pty_information2_o
463: => pqp_pty_shd.g_old_rec.pty_information2
464: ,p_pty_information3_o
465: => pqp_pty_shd.g_old_rec.pty_information3

Line 463: => pqp_pty_shd.g_old_rec.pty_information2

459: => pqp_pty_shd.g_old_rec.pty_information_category
460: ,p_pty_information1_o
461: => pqp_pty_shd.g_old_rec.pty_information1
462: ,p_pty_information2_o
463: => pqp_pty_shd.g_old_rec.pty_information2
464: ,p_pty_information3_o
465: => pqp_pty_shd.g_old_rec.pty_information3
466: ,p_pty_information4_o
467: => pqp_pty_shd.g_old_rec.pty_information4

Line 465: => pqp_pty_shd.g_old_rec.pty_information3

461: => pqp_pty_shd.g_old_rec.pty_information1
462: ,p_pty_information2_o
463: => pqp_pty_shd.g_old_rec.pty_information2
464: ,p_pty_information3_o
465: => pqp_pty_shd.g_old_rec.pty_information3
466: ,p_pty_information4_o
467: => pqp_pty_shd.g_old_rec.pty_information4
468: ,p_pty_information5_o
469: => pqp_pty_shd.g_old_rec.pty_information5

Line 467: => pqp_pty_shd.g_old_rec.pty_information4

463: => pqp_pty_shd.g_old_rec.pty_information2
464: ,p_pty_information3_o
465: => pqp_pty_shd.g_old_rec.pty_information3
466: ,p_pty_information4_o
467: => pqp_pty_shd.g_old_rec.pty_information4
468: ,p_pty_information5_o
469: => pqp_pty_shd.g_old_rec.pty_information5
470: ,p_pty_information6_o
471: => pqp_pty_shd.g_old_rec.pty_information6

Line 469: => pqp_pty_shd.g_old_rec.pty_information5

465: => pqp_pty_shd.g_old_rec.pty_information3
466: ,p_pty_information4_o
467: => pqp_pty_shd.g_old_rec.pty_information4
468: ,p_pty_information5_o
469: => pqp_pty_shd.g_old_rec.pty_information5
470: ,p_pty_information6_o
471: => pqp_pty_shd.g_old_rec.pty_information6
472: ,p_pty_information7_o
473: => pqp_pty_shd.g_old_rec.pty_information7

Line 471: => pqp_pty_shd.g_old_rec.pty_information6

467: => pqp_pty_shd.g_old_rec.pty_information4
468: ,p_pty_information5_o
469: => pqp_pty_shd.g_old_rec.pty_information5
470: ,p_pty_information6_o
471: => pqp_pty_shd.g_old_rec.pty_information6
472: ,p_pty_information7_o
473: => pqp_pty_shd.g_old_rec.pty_information7
474: ,p_pty_information8_o
475: => pqp_pty_shd.g_old_rec.pty_information8

Line 473: => pqp_pty_shd.g_old_rec.pty_information7

469: => pqp_pty_shd.g_old_rec.pty_information5
470: ,p_pty_information6_o
471: => pqp_pty_shd.g_old_rec.pty_information6
472: ,p_pty_information7_o
473: => pqp_pty_shd.g_old_rec.pty_information7
474: ,p_pty_information8_o
475: => pqp_pty_shd.g_old_rec.pty_information8
476: ,p_pty_information9_o
477: => pqp_pty_shd.g_old_rec.pty_information9

Line 475: => pqp_pty_shd.g_old_rec.pty_information8

471: => pqp_pty_shd.g_old_rec.pty_information6
472: ,p_pty_information7_o
473: => pqp_pty_shd.g_old_rec.pty_information7
474: ,p_pty_information8_o
475: => pqp_pty_shd.g_old_rec.pty_information8
476: ,p_pty_information9_o
477: => pqp_pty_shd.g_old_rec.pty_information9
478: ,p_pty_information10_o
479: => pqp_pty_shd.g_old_rec.pty_information10

Line 477: => pqp_pty_shd.g_old_rec.pty_information9

473: => pqp_pty_shd.g_old_rec.pty_information7
474: ,p_pty_information8_o
475: => pqp_pty_shd.g_old_rec.pty_information8
476: ,p_pty_information9_o
477: => pqp_pty_shd.g_old_rec.pty_information9
478: ,p_pty_information10_o
479: => pqp_pty_shd.g_old_rec.pty_information10
480: ,p_pty_information11_o
481: => pqp_pty_shd.g_old_rec.pty_information11

Line 479: => pqp_pty_shd.g_old_rec.pty_information10

475: => pqp_pty_shd.g_old_rec.pty_information8
476: ,p_pty_information9_o
477: => pqp_pty_shd.g_old_rec.pty_information9
478: ,p_pty_information10_o
479: => pqp_pty_shd.g_old_rec.pty_information10
480: ,p_pty_information11_o
481: => pqp_pty_shd.g_old_rec.pty_information11
482: ,p_pty_information12_o
483: => pqp_pty_shd.g_old_rec.pty_information12

Line 481: => pqp_pty_shd.g_old_rec.pty_information11

477: => pqp_pty_shd.g_old_rec.pty_information9
478: ,p_pty_information10_o
479: => pqp_pty_shd.g_old_rec.pty_information10
480: ,p_pty_information11_o
481: => pqp_pty_shd.g_old_rec.pty_information11
482: ,p_pty_information12_o
483: => pqp_pty_shd.g_old_rec.pty_information12
484: ,p_pty_information13_o
485: => pqp_pty_shd.g_old_rec.pty_information13

Line 483: => pqp_pty_shd.g_old_rec.pty_information12

479: => pqp_pty_shd.g_old_rec.pty_information10
480: ,p_pty_information11_o
481: => pqp_pty_shd.g_old_rec.pty_information11
482: ,p_pty_information12_o
483: => pqp_pty_shd.g_old_rec.pty_information12
484: ,p_pty_information13_o
485: => pqp_pty_shd.g_old_rec.pty_information13
486: ,p_pty_information14_o
487: => pqp_pty_shd.g_old_rec.pty_information14

Line 485: => pqp_pty_shd.g_old_rec.pty_information13

481: => pqp_pty_shd.g_old_rec.pty_information11
482: ,p_pty_information12_o
483: => pqp_pty_shd.g_old_rec.pty_information12
484: ,p_pty_information13_o
485: => pqp_pty_shd.g_old_rec.pty_information13
486: ,p_pty_information14_o
487: => pqp_pty_shd.g_old_rec.pty_information14
488: ,p_pty_information15_o
489: => pqp_pty_shd.g_old_rec.pty_information15

Line 487: => pqp_pty_shd.g_old_rec.pty_information14

483: => pqp_pty_shd.g_old_rec.pty_information12
484: ,p_pty_information13_o
485: => pqp_pty_shd.g_old_rec.pty_information13
486: ,p_pty_information14_o
487: => pqp_pty_shd.g_old_rec.pty_information14
488: ,p_pty_information15_o
489: => pqp_pty_shd.g_old_rec.pty_information15
490: ,p_pty_information16_o
491: => pqp_pty_shd.g_old_rec.pty_information16

Line 489: => pqp_pty_shd.g_old_rec.pty_information15

485: => pqp_pty_shd.g_old_rec.pty_information13
486: ,p_pty_information14_o
487: => pqp_pty_shd.g_old_rec.pty_information14
488: ,p_pty_information15_o
489: => pqp_pty_shd.g_old_rec.pty_information15
490: ,p_pty_information16_o
491: => pqp_pty_shd.g_old_rec.pty_information16
492: ,p_pty_information17_o
493: => pqp_pty_shd.g_old_rec.pty_information17

Line 491: => pqp_pty_shd.g_old_rec.pty_information16

487: => pqp_pty_shd.g_old_rec.pty_information14
488: ,p_pty_information15_o
489: => pqp_pty_shd.g_old_rec.pty_information15
490: ,p_pty_information16_o
491: => pqp_pty_shd.g_old_rec.pty_information16
492: ,p_pty_information17_o
493: => pqp_pty_shd.g_old_rec.pty_information17
494: ,p_pty_information18_o
495: => pqp_pty_shd.g_old_rec.pty_information18

Line 493: => pqp_pty_shd.g_old_rec.pty_information17

489: => pqp_pty_shd.g_old_rec.pty_information15
490: ,p_pty_information16_o
491: => pqp_pty_shd.g_old_rec.pty_information16
492: ,p_pty_information17_o
493: => pqp_pty_shd.g_old_rec.pty_information17
494: ,p_pty_information18_o
495: => pqp_pty_shd.g_old_rec.pty_information18
496: ,p_pty_information19_o
497: => pqp_pty_shd.g_old_rec.pty_information19

Line 495: => pqp_pty_shd.g_old_rec.pty_information18

491: => pqp_pty_shd.g_old_rec.pty_information16
492: ,p_pty_information17_o
493: => pqp_pty_shd.g_old_rec.pty_information17
494: ,p_pty_information18_o
495: => pqp_pty_shd.g_old_rec.pty_information18
496: ,p_pty_information19_o
497: => pqp_pty_shd.g_old_rec.pty_information19
498: ,p_pty_information20_o
499: => pqp_pty_shd.g_old_rec.pty_information20

Line 497: => pqp_pty_shd.g_old_rec.pty_information19

493: => pqp_pty_shd.g_old_rec.pty_information17
494: ,p_pty_information18_o
495: => pqp_pty_shd.g_old_rec.pty_information18
496: ,p_pty_information19_o
497: => pqp_pty_shd.g_old_rec.pty_information19
498: ,p_pty_information20_o
499: => pqp_pty_shd.g_old_rec.pty_information20
500: ,p_special_pension_type_code_o
501: => pqp_pty_shd.g_old_rec.special_pension_type_code

Line 499: => pqp_pty_shd.g_old_rec.pty_information20

495: => pqp_pty_shd.g_old_rec.pty_information18
496: ,p_pty_information19_o
497: => pqp_pty_shd.g_old_rec.pty_information19
498: ,p_pty_information20_o
499: => pqp_pty_shd.g_old_rec.pty_information20
500: ,p_special_pension_type_code_o
501: => pqp_pty_shd.g_old_rec.special_pension_type_code
502: ,p_pension_sub_category_o
503: => pqp_pty_shd.g_old_rec.pension_sub_category

Line 501: => pqp_pty_shd.g_old_rec.special_pension_type_code

497: => pqp_pty_shd.g_old_rec.pty_information19
498: ,p_pty_information20_o
499: => pqp_pty_shd.g_old_rec.pty_information20
500: ,p_special_pension_type_code_o
501: => pqp_pty_shd.g_old_rec.special_pension_type_code
502: ,p_pension_sub_category_o
503: => pqp_pty_shd.g_old_rec.pension_sub_category
504: ,p_pension_basis_calc_method_o
505: => pqp_pty_shd.g_old_rec.pension_basis_calc_method

Line 503: => pqp_pty_shd.g_old_rec.pension_sub_category

499: => pqp_pty_shd.g_old_rec.pty_information20
500: ,p_special_pension_type_code_o
501: => pqp_pty_shd.g_old_rec.special_pension_type_code
502: ,p_pension_sub_category_o
503: => pqp_pty_shd.g_old_rec.pension_sub_category
504: ,p_pension_basis_calc_method_o
505: => pqp_pty_shd.g_old_rec.pension_basis_calc_method
506: ,p_pension_salary_balance_o
507: => pqp_pty_shd.g_old_rec.pension_salary_balance

Line 505: => pqp_pty_shd.g_old_rec.pension_basis_calc_method

501: => pqp_pty_shd.g_old_rec.special_pension_type_code
502: ,p_pension_sub_category_o
503: => pqp_pty_shd.g_old_rec.pension_sub_category
504: ,p_pension_basis_calc_method_o
505: => pqp_pty_shd.g_old_rec.pension_basis_calc_method
506: ,p_pension_salary_balance_o
507: => pqp_pty_shd.g_old_rec.pension_salary_balance
508: ,p_recurring_bonus_percent_o
509: => pqp_pty_shd.g_old_rec.recurring_bonus_percent

Line 507: => pqp_pty_shd.g_old_rec.pension_salary_balance

503: => pqp_pty_shd.g_old_rec.pension_sub_category
504: ,p_pension_basis_calc_method_o
505: => pqp_pty_shd.g_old_rec.pension_basis_calc_method
506: ,p_pension_salary_balance_o
507: => pqp_pty_shd.g_old_rec.pension_salary_balance
508: ,p_recurring_bonus_percent_o
509: => pqp_pty_shd.g_old_rec.recurring_bonus_percent
510: ,p_non_recur_bonus_percent_o
511: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent

Line 509: => pqp_pty_shd.g_old_rec.recurring_bonus_percent

505: => pqp_pty_shd.g_old_rec.pension_basis_calc_method
506: ,p_pension_salary_balance_o
507: => pqp_pty_shd.g_old_rec.pension_salary_balance
508: ,p_recurring_bonus_percent_o
509: => pqp_pty_shd.g_old_rec.recurring_bonus_percent
510: ,p_non_recur_bonus_percent_o
511: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
512: ,p_recurring_bonus_balance_o
513: => pqp_pty_shd.g_old_rec.recurring_bonus_balance

Line 511: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent

507: => pqp_pty_shd.g_old_rec.pension_salary_balance
508: ,p_recurring_bonus_percent_o
509: => pqp_pty_shd.g_old_rec.recurring_bonus_percent
510: ,p_non_recur_bonus_percent_o
511: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
512: ,p_recurring_bonus_balance_o
513: => pqp_pty_shd.g_old_rec.recurring_bonus_balance
514: ,p_non_recur_bonus_balance_o
515: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance

Line 513: => pqp_pty_shd.g_old_rec.recurring_bonus_balance

509: => pqp_pty_shd.g_old_rec.recurring_bonus_percent
510: ,p_non_recur_bonus_percent_o
511: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
512: ,p_recurring_bonus_balance_o
513: => pqp_pty_shd.g_old_rec.recurring_bonus_balance
514: ,p_non_recur_bonus_balance_o
515: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
516: ,p_std_tax_reduction_o
517: => pqp_pty_shd.g_old_rec.std_tax_reduction

Line 515: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance

511: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
512: ,p_recurring_bonus_balance_o
513: => pqp_pty_shd.g_old_rec.recurring_bonus_balance
514: ,p_non_recur_bonus_balance_o
515: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
516: ,p_std_tax_reduction_o
517: => pqp_pty_shd.g_old_rec.std_tax_reduction
518: ,p_spl_tax_reduction_o
519: => pqp_pty_shd.g_old_rec.spl_tax_reduction

Line 517: => pqp_pty_shd.g_old_rec.std_tax_reduction

513: => pqp_pty_shd.g_old_rec.recurring_bonus_balance
514: ,p_non_recur_bonus_balance_o
515: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
516: ,p_std_tax_reduction_o
517: => pqp_pty_shd.g_old_rec.std_tax_reduction
518: ,p_spl_tax_reduction_o
519: => pqp_pty_shd.g_old_rec.spl_tax_reduction
520: ,p_sig_sal_spl_tax_reduction_o
521: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction

Line 519: => pqp_pty_shd.g_old_rec.spl_tax_reduction

515: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
516: ,p_std_tax_reduction_o
517: => pqp_pty_shd.g_old_rec.std_tax_reduction
518: ,p_spl_tax_reduction_o
519: => pqp_pty_shd.g_old_rec.spl_tax_reduction
520: ,p_sig_sal_spl_tax_reduction_o
521: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
522: ,p_sig_sal_non_tax_reduction_o
523: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction

Line 521: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction

517: => pqp_pty_shd.g_old_rec.std_tax_reduction
518: ,p_spl_tax_reduction_o
519: => pqp_pty_shd.g_old_rec.spl_tax_reduction
520: ,p_sig_sal_spl_tax_reduction_o
521: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
522: ,p_sig_sal_non_tax_reduction_o
523: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
524: ,p_sig_sal_std_tax_reduction_o
525: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction

Line 523: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction

519: => pqp_pty_shd.g_old_rec.spl_tax_reduction
520: ,p_sig_sal_spl_tax_reduction_o
521: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
522: ,p_sig_sal_non_tax_reduction_o
523: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
524: ,p_sig_sal_std_tax_reduction_o
525: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
526: ,p_sii_std_tax_reduction_o
527: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction

Line 525: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction

521: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
522: ,p_sig_sal_non_tax_reduction_o
523: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
524: ,p_sig_sal_std_tax_reduction_o
525: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
526: ,p_sii_std_tax_reduction_o
527: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
528: ,p_sii_spl_tax_reduction_o
529: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction

Line 527: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction

523: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
524: ,p_sig_sal_std_tax_reduction_o
525: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
526: ,p_sii_std_tax_reduction_o
527: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
528: ,p_sii_spl_tax_reduction_o
529: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
530: ,p_sii_non_tax_reduction_o
531: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction

Line 529: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction

525: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
526: ,p_sii_std_tax_reduction_o
527: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
528: ,p_sii_spl_tax_reduction_o
529: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
530: ,p_sii_non_tax_reduction_o
531: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
532: ,p_prev_year_bonus_include_o
533: => pqp_pty_shd.g_old_rec.previous_year_bonus_included

Line 531: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction

527: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
528: ,p_sii_spl_tax_reduction_o
529: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
530: ,p_sii_non_tax_reduction_o
531: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
532: ,p_prev_year_bonus_include_o
533: => pqp_pty_shd.g_old_rec.previous_year_bonus_included
534: ,p_recurring_bonus_period_o
535: => pqp_pty_shd.g_old_rec.recurring_bonus_period

Line 533: => pqp_pty_shd.g_old_rec.previous_year_bonus_included

529: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
530: ,p_sii_non_tax_reduction_o
531: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
532: ,p_prev_year_bonus_include_o
533: => pqp_pty_shd.g_old_rec.previous_year_bonus_included
534: ,p_recurring_bonus_period_o
535: => pqp_pty_shd.g_old_rec.recurring_bonus_period
536: ,p_non_recurring_bonus_period_o
537: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period

Line 535: => pqp_pty_shd.g_old_rec.recurring_bonus_period

531: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
532: ,p_prev_year_bonus_include_o
533: => pqp_pty_shd.g_old_rec.previous_year_bonus_included
534: ,p_recurring_bonus_period_o
535: => pqp_pty_shd.g_old_rec.recurring_bonus_period
536: ,p_non_recurring_bonus_period_o
537: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
538: ,p_ee_age_threshold_o
539: => pqp_pty_shd.g_old_rec.ee_age_threshold

Line 537: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period

533: => pqp_pty_shd.g_old_rec.previous_year_bonus_included
534: ,p_recurring_bonus_period_o
535: => pqp_pty_shd.g_old_rec.recurring_bonus_period
536: ,p_non_recurring_bonus_period_o
537: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
538: ,p_ee_age_threshold_o
539: => pqp_pty_shd.g_old_rec.ee_age_threshold
540: ,p_er_age_threshold_o
541: => pqp_pty_shd.g_old_rec.er_age_threshold

Line 539: => pqp_pty_shd.g_old_rec.ee_age_threshold

535: => pqp_pty_shd.g_old_rec.recurring_bonus_period
536: ,p_non_recurring_bonus_period_o
537: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
538: ,p_ee_age_threshold_o
539: => pqp_pty_shd.g_old_rec.ee_age_threshold
540: ,p_er_age_threshold_o
541: => pqp_pty_shd.g_old_rec.er_age_threshold
542: ,p_ee_age_contribution_o
543: => pqp_pty_shd.g_old_rec.ee_age_contribution

Line 541: => pqp_pty_shd.g_old_rec.er_age_threshold

537: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
538: ,p_ee_age_threshold_o
539: => pqp_pty_shd.g_old_rec.ee_age_threshold
540: ,p_er_age_threshold_o
541: => pqp_pty_shd.g_old_rec.er_age_threshold
542: ,p_ee_age_contribution_o
543: => pqp_pty_shd.g_old_rec.ee_age_contribution
544: ,p_er_age_contribution_o
545: => pqp_pty_shd.g_old_rec.er_age_contribution

Line 543: => pqp_pty_shd.g_old_rec.ee_age_contribution

539: => pqp_pty_shd.g_old_rec.ee_age_threshold
540: ,p_er_age_threshold_o
541: => pqp_pty_shd.g_old_rec.er_age_threshold
542: ,p_ee_age_contribution_o
543: => pqp_pty_shd.g_old_rec.ee_age_contribution
544: ,p_er_age_contribution_o
545: => pqp_pty_shd.g_old_rec.er_age_contribution
546: );
547: --

Line 545: => pqp_pty_shd.g_old_rec.er_age_contribution

541: => pqp_pty_shd.g_old_rec.er_age_threshold
542: ,p_ee_age_contribution_o
543: => pqp_pty_shd.g_old_rec.ee_age_contribution
544: ,p_er_age_contribution_o
545: => pqp_pty_shd.g_old_rec.er_age_contribution
546: );
547: --
548: exception
549: --

Line 567: ,p_rec in out nocopy pqp_pty_shd.g_rec_type

563: -- ----------------------------------------------------------------------------
564: Procedure del
565: (p_effective_date in date
566: ,p_datetrack_mode in varchar2
567: ,p_rec in out nocopy pqp_pty_shd.g_rec_type
568: ) is
569: --
570: l_proc varchar2(72) := g_package||'del';
571: l_validation_start_date date;

Line 583: pqp_pty_shd.lck

579: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
580: --
581: -- We must lock the row which we need to delete.
582: --
583: pqp_pty_shd.lck
584: (p_effective_date => p_effective_date
585: ,p_datetrack_mode => p_datetrack_mode
586: ,p_pension_type_id => p_rec.pension_type_id
587: ,p_object_version_number => p_rec.object_version_number

Line 663: l_rec pqp_pty_shd.g_rec_type;

659: from pqp_pension_types_f
660: where
661: pension_type_id = c_pension_type_id;
662: --
663: l_rec pqp_pty_shd.g_rec_type;
664: l_proc varchar2(72) := g_package||'del';
665: l_business_group_id pqp_pension_types_f.business_group_id%TYPE;
666: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
667: --