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:
16: l_plan_id pay_accrual_plans.ACCRUAL_PLAN_ID%type;
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;
18:
33: p_evaluation_date IN DATE,
34: p_business_group_id in varchar2
35: ) IS
36: select pet.element_type_id
37: from pay_element_types_f pet,
38: pay_element_type_rules per
39: where per.element_set_id = p_element_set_id
40: AND pet.business_group_id=p_business_group_id
41: and per.include_or_exclude = 'I'
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 */
73: WHERE
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:
245: l_plan_id pay_accrual_plans.ACCRUAL_PLAN_ID%type;
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;
247: