APPS.PER_DISPLAY_ACCRUAL_BALANCE dependencies on PER_ALL_ASSIGNMENTS_F

Line 11: l_business_group_id per_all_assignments_f.BUSINESS_GROUP_ID%type;

7: p_evaluation_date IN DATE ,
8: p_accrual_balance_table OUT NOCOPY PER_ACCRUAL_BALANCE_TABLE_TYPE,
9: p_error_message OUT NOCOPY VARCHAR2)IS
10:
11: l_business_group_id per_all_assignments_f.BUSINESS_GROUP_ID%type;
12: l_element_type_id pay_element_types_f.ELEMENT_TYPE_ID%type;
13: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
14: l_payroll_id pay_element_types_f.ELEMENT_TYPE_ID%type;
15:

Line 13: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;

9: p_error_message OUT NOCOPY VARCHAR2)IS
10:
11: l_business_group_id per_all_assignments_f.BUSINESS_GROUP_ID%type;
12: l_element_type_id pay_element_types_f.ELEMENT_TYPE_ID%type;
13: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
14: l_payroll_id pay_element_types_f.ELEMENT_TYPE_ID%type;
15:
16: l_plan_id pay_accrual_plans.ACCRUAL_PLAN_ID%type;
17: l_name pay_accrual_plans.ACCRUAL_PLAN_NAME%type;

Line 51: FROM PER_ALL_ASSIGNMENTS_F pas,

47: p_evaluation_date In Date) IS
48: SELECT pas.ASSIGNMENT_ID,
49: pas.payroll_id,
50: pas.business_group_id
51: FROM PER_ALL_ASSIGNMENTS_F pas,
52: per_assignment_status_types typ
53: WHERE pas.PERSON_ID = p_resource_id
54: AND pas.ASSIGNMENT_TYPE in ('E','C')
55: AND pas.PRIMARY_FLAG = 'Y'

Line 202: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;

198: function IsTerminatedEmployee(p_resource_id IN NUMBER,
199: p_evaluation_date IN DATE)
200: return varchar2
201: is
202: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
203: CURSOR c_assignments(p_resource_id In Number,
204: p_evaluation_date In Date) IS
205: SELECT pas.ASSIGNMENT_ID
206: FROM PER_ALL_ASSIGNMENTS_F pas,

Line 206: FROM PER_ALL_ASSIGNMENTS_F pas,

202: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
203: CURSOR c_assignments(p_resource_id In Number,
204: p_evaluation_date In Date) IS
205: SELECT pas.ASSIGNMENT_ID
206: FROM PER_ALL_ASSIGNMENTS_F pas,
207: per_assignment_status_types typ
208: WHERE pas.PERSON_ID = p_resource_id
209: AND pas.ASSIGNMENT_TYPE in ('E','C')
210: AND pas.PRIMARY_FLAG = 'Y'

Line 233: l_business_group_id per_all_assignments_f.BUSINESS_GROUP_ID%type;

229: p_evaluation_function in varchar2,
230: p_evaluation_date IN DATE ,
231: p_accrual_balance_table OUT NOCOPY PER_ACCRUAL_BALANCE_TABLE_TYPE)IS
232:
233: l_business_group_id per_all_assignments_f.BUSINESS_GROUP_ID%type;
234: l_element_type_id pay_element_types_f.ELEMENT_TYPE_ID%type;
235: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
236: l_payroll_id pay_element_types_f.ELEMENT_TYPE_ID%type;
237:

Line 235: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;

231: p_accrual_balance_table OUT NOCOPY PER_ACCRUAL_BALANCE_TABLE_TYPE)IS
232:
233: l_business_group_id per_all_assignments_f.BUSINESS_GROUP_ID%type;
234: l_element_type_id pay_element_types_f.ELEMENT_TYPE_ID%type;
235: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
236: l_payroll_id pay_element_types_f.ELEMENT_TYPE_ID%type;
237:
238: l_plan_id pay_accrual_plans.ACCRUAL_PLAN_ID%type;
239: l_name pay_accrual_plans.ACCRUAL_PLAN_NAME%type;

Line 259: FROM PER_ALL_ASSIGNMENTS_F pas,

255: p_evaluation_date In Date) IS
256: SELECT pas.ASSIGNMENT_ID,
257: pas.payroll_id,
258: pas.business_group_id
259: FROM PER_ALL_ASSIGNMENTS_F pas,
260: per_assignment_status_types typ
261: WHERE pas.PERSON_ID = p_resource_id
262: AND pas.ASSIGNMENT_TYPE in ('E','C')
263: AND pas.PRIMARY_FLAG = 'Y'