DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 16: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

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: ------------------------------------------------------------------------

Line 30: ( p_assignment_id IN per_all_assignments_f.assignment_id%type,

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:

Line 82: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

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: ------------------------------------------------------------------------

Line 90: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

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: ------------------------------------------------------------------------

Line 98: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

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

Line 105: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

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: ------------------------------------------------------------------------

Line 113: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

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: --