12: ------------------------------------------------------------------------
13: -- Function LOCAL_NATNATIONALITY_MATCHES
14: ------------------------------------------------------------------------
15: function local_nationality_matches
16: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
17: p_date_earned IN Date)
18: return varchar2;
19:
20: ------------------------------------------------------------------------
26: ------------------------------------------------------------------------
27: -- Function GET_PERSON_NATIONALITY
28: ------------------------------------------------------------------------
29: function get_person_nationality
30: ( p_assignment_id IN per_all_assignments_f.assignment_id%type,
31: p_date_earned IN Date) RETURN varchar2;
32:
33: ------------------------------------------------------------------------
34:
78: ------------------------------------------------------------------------
79: -- Function get_contract
80: ------------------------------------------------------------------------
81: function get_contract
82: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
83: p_date_earned IN Date)
84: return varchar2;
85:
86: ------------------------------------------------------------------------
86: ------------------------------------------------------------------------
87: -- Function get_probation_period
88: ------------------------------------------------------------------------
89: function get_probation_period
90: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
91: p_date_earned IN Date)
92: return date;
93:
94: ------------------------------------------------------------------------
94: ------------------------------------------------------------------------
95: -- Function get_contract_expiry_status
96: ------------------------------------------------------------------------
97: function get_contract_expiry_status
98: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
99: p_date_earned IN Date)
100: return varchar2;
101: ------------------------------------------------------------------------
102: -- Function get_termination_initiator
101: ------------------------------------------------------------------------
102: -- Function get_termination_initiator
103: ------------------------------------------------------------------------
104: function get_termination_initiator
105: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
106: p_date_earned IN Date)
107: return varchar2;
108:
109: ------------------------------------------------------------------------
109: ------------------------------------------------------------------------
110: -- Function user_gratuity_formula_exists
111: ------------------------------------------------------------------------
112: function user_gratuity_formula_exists
113: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
114: p_date_earned IN Date)
115: return varchar2;
116:
117: --