9:
10: TYPE tfn_flags_record IS RECORD
11: (
12: k_assignment_id per_all_assignments_f.assignment_id%TYPE,
13: australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,
14: tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE,
15: fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE,
16: basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE,
17: hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
10: TYPE tfn_flags_record IS RECORD
11: (
12: k_assignment_id per_all_assignments_f.assignment_id%TYPE,
13: australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,
14: tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE,
15: fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE,
16: basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE,
17: hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
18: sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
11: (
12: k_assignment_id per_all_assignments_f.assignment_id%TYPE,
13: australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,
14: tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE,
15: fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE,
16: basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE,
17: hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
18: sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
19: declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE,
12: k_assignment_id per_all_assignments_f.assignment_id%TYPE,
13: australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,
14: tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE,
15: fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE,
16: basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE,
17: hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
18: sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
19: declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE,
20: rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE,
13: australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,
14: tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE,
15: fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE,
16: basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE,
17: hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
18: sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
19: declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE,
20: rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE,
21: tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE,
14: tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE,
15: fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE,
16: basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE,
17: hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
18: sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
19: declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE,
20: rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE,
21: tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE,
22: effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE,
15: fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE,
16: basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE,
17: hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
18: sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
19: declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE,
20: rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE,
21: tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE,
22: effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE,
23: tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE,
16: basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE,
17: hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
18: sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
19: declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE,
20: rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE,
21: tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE,
22: effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE,
23: tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE,
24: senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,/*bug7270073*/
17: hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
18: sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
19: declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE,
20: rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE,
21: tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE,
22: effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE,
23: tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE,
24: senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,/*bug7270073*/
25: current_or_terminated varchar2(1)
18: sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
19: declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE,
20: rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE,
21: tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE,
22: effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE,
23: tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE,
24: senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,/*bug7270073*/
25: current_or_terminated varchar2(1)
26: );
20: rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE,
21: tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE,
22: effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE,
23: tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE,
24: senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,/*bug7270073*/
25: current_or_terminated varchar2(1)
26: );
27:
28: TYPE tfn_flags_table IS TABLE OF tfn_flags_record INDEX BY BINARY_INTEGER;