APPS.PER_DISPLAY_ACCRUAL_BALANCE dependencies on PAY_ELEMENT_TYPES_F

Line 12: l_element_type_id pay_element_types_f.ELEMENT_TYPE_ID%type;

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;

Line 14: l_payroll_id pay_element_types_f.ELEMENT_TYPE_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:

Line 37: from pay_element_types_f pet,

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'

Line 69: ,pay_element_types_f pet

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
73: pee.assignment_id = p_assignment_id

Line 234: l_element_type_id pay_element_types_f.ELEMENT_TYPE_ID%type;

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:
238: l_plan_id pay_accrual_plans.ACCRUAL_PLAN_ID%type;

Line 236: l_payroll_id pay_element_types_f.ELEMENT_TYPE_ID%type;

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;
240: