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 PAY_ACCRUAL_PLANS

Line 16: l_plan_id pay_accrual_plans.ACCRUAL_PLAN_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;
18:
19: l_accrual number;
20: l_net_accrual number;

Line 17: l_name pay_accrual_plans.ACCRUAL_PLAN_NAME%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;
18:
19: l_accrual number;
20: l_net_accrual number;
21: l_start_date Date;

Line 29: l_leave_type_balance pay_accrual_plans.information1%type; /* 4767298 */

25:
26: l_legislation_code per_business_groups_perf.legislation_code%type;
27: l_return Number;
28:
29: l_leave_type_balance pay_accrual_plans.information1%type; /* 4767298 */
30: l_information_Category pay_accrual_plans.information_category%type; /* 4767298 */
31:
32: CURSOR c_element_set(p_element_set IN NUMBER,
33: p_evaluation_date IN DATE,

Line 30: l_information_Category pay_accrual_plans.information_category%type; /* 4767298 */

26: l_legislation_code per_business_groups_perf.legislation_code%type;
27: l_return Number;
28:
29: l_leave_type_balance pay_accrual_plans.information1%type; /* 4767298 */
30: l_information_Category pay_accrual_plans.information_category%type; /* 4767298 */
31:
32: CURSOR c_element_set(p_element_set IN NUMBER,
33: p_evaluation_date IN DATE,
34: p_business_group_id in varchar2

Line 68: FROM pay_accrual_plans pap

64: SELECT pap.accrual_plan_id,
65: pap.accrual_plan_name,
66: pap.information1, /* 4767298 */
67: pap.information_Category /* 4767298 */
68: FROM pay_accrual_plans pap
69: ,pay_element_types_f pet
70: ,pay_element_links_f pel
71: ,pay_element_entries_f pee
72: WHERE

Line 238: l_plan_id pay_accrual_plans.ACCRUAL_PLAN_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;
240:
241: l_accrual number;
242: l_net_accrual number;

Line 239: l_name pay_accrual_plans.ACCRUAL_PLAN_NAME%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;
240:
241: l_accrual number;
242: l_net_accrual number;
243: l_start_date Date;

Line 251: l_leave_type_balance pay_accrual_plans.information1%type; /* 4767298 */

247:
248: l_legislation_code per_business_groups_perf.legislation_code%type;
249: l_return Number;
250:
251: l_leave_type_balance pay_accrual_plans.information1%type; /* 4767298 */
252: l_information_Category pay_accrual_plans.information_category%type; /* 4767298 */
253:
254: CURSOR c_assignments(p_resource_id In Number,
255: p_evaluation_date In Date) IS

Line 252: l_information_Category pay_accrual_plans.information_category%type; /* 4767298 */

248: l_legislation_code per_business_groups_perf.legislation_code%type;
249: l_return Number;
250:
251: l_leave_type_balance pay_accrual_plans.information1%type; /* 4767298 */
252: l_information_Category pay_accrual_plans.information_category%type; /* 4767298 */
253:
254: CURSOR c_assignments(p_resource_id In Number,
255: p_evaluation_date In Date) IS
256: SELECT pas.ASSIGNMENT_ID,