APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on PAY_ALL_PAYROLLS_F

Line 6: CURSOR cur_element_entry_assignment (p_end_date date,p_payroll_id pay_all_payrolls_f.payroll_id%type) IS

2: /* $Header: pygbpaer.pkb 120.0.12020000.6 2012/11/21 13:18:13 ssanjays noship $ */
3: AS
4:
5:
6: CURSOR cur_element_entry_assignment (p_end_date date,p_payroll_id pay_all_payrolls_f.payroll_id%type) IS
7: SELECT pay_element_entries_f.element_entry_id element_entry_id, per_all_assignments_f.assignment_id assignment_id
8: FROM pay_element_entries_f, pay_element_types_f , per_all_assignments_f,PER_ASSIGNMENT_STATUS_TYPES PAST
9: WHERE pay_element_entries_f.element_type_id = pay_element_types_f.element_type_id
10: AND per_all_assignments_f.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID

Line 68: select payroll_name from pay_all_payrolls_f where payroll_id = p_payroll

64: from per_time_periods
65: where TIME_PERIOD_ID=p_period and payroll_id =p_payroll_id;
66:
67: cursor cur_payroll_name(p_payroll number,p_end_date date) is
68: select payroll_name from pay_all_payrolls_f where payroll_id = p_payroll
69: AND p_end_date between effective_start_date and effective_end_date;
70:
71:
72: procedure generate( p_employer NUMBER