[Home] [Help]
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;
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;
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,
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
64: SELECT pap.accrual_plan_id,
65: pap_tl.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: ,pay_accrual_plans_tl pap_tl /* 14387376 */
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: ,pay_accrual_plans_tl pap_tl /* 14387376 */
73: WHERE
74: pee.assignment_id = p_assignment_id
75: AND
76: pet.ELEMENT_TYPE_ID=p_element_type_id
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;
247:
248: l_accrual number;
249: l_net_accrual number;
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;
247:
248: l_accrual number;
249: l_net_accrual number;
250: l_start_date Date;
254:
255: l_legislation_code per_business_groups_perf.legislation_code%type;
256: l_return Number;
257:
258: l_leave_type_balance pay_accrual_plans.information1%type; /* 4767298 */
259: l_information_Category pay_accrual_plans.information_category%type; /* 4767298 */
260:
261: CURSOR c_assignments(p_resource_id In Number,
262: p_evaluation_date In Date) IS
255: l_legislation_code per_business_groups_perf.legislation_code%type;
256: l_return Number;
257:
258: l_leave_type_balance pay_accrual_plans.information1%type; /* 4767298 */
259: l_information_Category pay_accrual_plans.information_category%type; /* 4767298 */
260:
261: CURSOR c_assignments(p_resource_id In Number,
262: p_evaluation_date In Date) IS
263: SELECT pas.ASSIGNMENT_ID,
280: pap_v.information1, /* 4767298 */
281: pap_v.information_Category /* 4767298 */
282: FROM
283: PAY_VIEW_ACCRUAL_PLANS_V pap_v
284: ,pay_accrual_plans_tl pap_tl /* 14387376 */
285: WHERE pap_v.ASSIGNMENT_ID = p_assignment_id
286: AND pap_v.accrual_plan_id = pap_tl.accrual_plan_id
287: AND pap_tl.LANGUAGE(+) = userenv('LANG')
288: AND p_evaluation_date BETWEEN pap_v.ASG_EFFECTIVE_START_DATE AND pap_v.ASG_EFFECTIVE_END_DATE