eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on PAY_AU_TFN_TAX_INFO_V

Line 49: /* Bug 4514282 - Removed the view pay_au_tfn_tax_info_v*/

45:
46: /* Bug 2728358 - Added check for employee terminated on report end date */
47:
48: /*Bug2920725 Corrected base tables to support security model*/
49: /* Bug 4514282 - Removed the view pay_au_tfn_tax_info_v*/
50:
51: /* bUG 4925794 - Modified the cursor added per_people_f and its relative joins */
52: /* Bug#5864230 moved join pee.entry_information_category = 'AU_TAX DEDUCTIONS' inside expression */
53:

Line 283: l_australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE;

279: AND c_report_end_date BETWEEN pet.effective_start_date AND pet.effective_end_date
280: AND c_report_end_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
281:
282: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
283: l_australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE;
284: l_tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE;
285: l_fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE;
286: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;
287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;

Line 284: l_tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE;

280: AND c_report_end_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
281:
282: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
283: l_australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE;
284: l_tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE;
285: l_fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE;
286: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;
287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;
288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;

Line 285: l_fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE;

281:
282: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
283: l_australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE;
284: l_tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE;
285: l_fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE;
286: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;
287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;
288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;
289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;

Line 286: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;

282: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
283: l_australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE;
284: l_tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE;
285: l_fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE;
286: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;
287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;
288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;
289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;
290: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;

Line 287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;

283: l_australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE;
284: l_tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE;
285: l_fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE;
286: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;
287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;
288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;
289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;
290: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;
291: l_tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE;

Line 288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;

284: l_tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE;
285: l_fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE;
286: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;
287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;
288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;
289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;
290: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;
291: l_tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE;
292: l_effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE;

Line 289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;

285: l_fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE;
286: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;
287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;
288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;
289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;
290: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;
291: l_tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE;
292: l_effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE;
293: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

Line 290: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;

286: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;
287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;
288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;
289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;
290: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;
291: l_tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE;
292: l_effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE;
293: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
294: l_current_or_terminated varchar2(1);

Line 291: l_tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE;

287: l_hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE;
288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;
289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;
290: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;
291: l_tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE;
292: l_effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE;
293: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
294: l_current_or_terminated varchar2(1);
295: l_tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE;

Line 292: l_effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE;

288: l_sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE;
289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;
290: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;
291: l_tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE;
292: l_effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE;
293: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
294: l_current_or_terminated varchar2(1);
295: l_tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE;
296: l_senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE; /*bug7270073*/

Line 296: l_senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE; /bug7270073/

292: l_effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE;
293: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
294: l_current_or_terminated varchar2(1);
295: l_tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE;
296: l_senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE; /*bug7270073*/
297: l_super_assignment_id per_all_assignments_f.assignment_id%TYPE;
298:
299: BEGIN
300: