APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on PER_ALL_ASSIGNMENTS_F

Line 26: k_assignment_id per_all_assignments_f.assignment_id%TYPE,

22: -- Record used store the Superannuation details of the employee
23:
24: TYPE spr_flag_record IS RECORD
25: (
26: k_assignment_id per_all_assignments_f.assignment_id%TYPE,
27: tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE
28: );
29:
30: TYPE spr_flag_table IS TABLE OF spr_flag_record INDEX BY BINARY_INTEGER;

Line 92: , per_all_assignments_f paa,/*Bug 3012794*/

88: , decode(sign(nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) - c_report_end_date),
89: 1,null,pps.actual_termination_date) actual_termination_date
90: , decode(eev0.screen_entry_value,'YS','Y','YI','Y','YC','Y','NN','N','YN','N','Y','N','N','N',Null) /*bug7270073*/
91: FROM per_people_f pap /* Bug 4925794 */
92: , per_all_assignments_f paa,/*Bug 3012794*/
93: hr_soft_coding_keyflex hsc,
94: per_periods_of_service pps
95: , pay_element_entries_f pee
96: , pay_element_types_f pet

Line 282: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

278: )
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;

Line 297: l_super_assignment_id per_all_assignments_f.assignment_id%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:
301: hr_utility.trace('Start of populate_tfn_flags procedure');

Line 424: FUNCTION get_tfn_flag_values(p_assignment_id in per_all_assignments_f.assignment_id%TYPE,

420: -- It uses the plsql table, searches the assignment_id and returns the value
421: -- of the flag that is passed as the parameter.
422: ------------------------------------------------------------------------------+
423:
424: FUNCTION get_tfn_flag_values(p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
425: p_flag_name in varchar2) RETURN varchar2 IS
426: BEGIN
427:
428: hr_utility.trace('Start of get_tfn_flag_values function');