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.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 209: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;

205: function IsTerminatedEmployee(p_resource_id IN NUMBER,
206: p_evaluation_date IN DATE)
207: return varchar2
208: is
209: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
210: CURSOR c_assignments(p_resource_id In Number,
211: p_evaluation_date In Date) IS
212: SELECT pas.ASSIGNMENT_ID
213: FROM PER_ALL_ASSIGNMENTS_F pas,

Line 213: FROM PER_ALL_ASSIGNMENTS_F pas,

209: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
210: CURSOR c_assignments(p_resource_id In Number,
211: p_evaluation_date In Date) IS
212: SELECT pas.ASSIGNMENT_ID
213: FROM PER_ALL_ASSIGNMENTS_F pas,
214: per_assignment_status_types typ
215: WHERE pas.PERSON_ID = p_resource_id
216: AND pas.ASSIGNMENT_TYPE in ('E','C')
217: AND pas.PRIMARY_FLAG = 'Y'

Line 240: l_business_group_id per_all_assignments_f.BUSINESS_GROUP_ID%type;

236: p_evaluation_function in varchar2,
237: p_evaluation_date IN DATE ,
238: p_accrual_balance_table OUT NOCOPY PER_ACCRUAL_BALANCE_TABLE_TYPE)IS
239:
240: l_business_group_id per_all_assignments_f.BUSINESS_GROUP_ID%type;
241: l_element_type_id pay_element_types_f.ELEMENT_TYPE_ID%type;
242: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
243: l_payroll_id pay_element_types_f.ELEMENT_TYPE_ID%type;
244:

Line 242: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;

238: p_accrual_balance_table OUT NOCOPY PER_ACCRUAL_BALANCE_TABLE_TYPE)IS
239:
240: l_business_group_id per_all_assignments_f.BUSINESS_GROUP_ID%type;
241: l_element_type_id pay_element_types_f.ELEMENT_TYPE_ID%type;
242: l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type;
243: l_payroll_id pay_element_types_f.ELEMENT_TYPE_ID%type;
244:
245: l_plan_id pay_accrual_plans.ACCRUAL_PLAN_ID%type;
246: l_name pay_accrual_plans.ACCRUAL_PLAN_NAME%type;