APPS.PAY_AU_RECONCILIATION_PKG dependencies on PAY_PAYROLLS_F

Line 3039: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688800*/

3035: per_assignments_f paa,
3036: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
3037: hr_all_organization_units hou, /*Bug 4132525*/
3038: hr_all_organization_units hou1 /*Bug 4132525*/
3039: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688800*/
3040: where pap.person_id = paa.person_id
3041: and paa.assignment_id = c_assignment_id
3042: and paa.business_group_id = c_business_group_id
3043: AND hsc.soft_coding_keyflex_id = paa.soft_coding_keyflex_id /*Bug 4040688*/

Line 3062: pay_payrolls_f pay

3058: CURSOR c_get_payroll_name(c_assignment_id number,c_end_date date, c_start_date date)
3059: IS
3060: SELECT paaf.payroll_id, pay.payroll_name
3061: FROM per_all_assignments_f paaf,
3062: pay_payrolls_f pay
3063: WHERE paaf.assignment_id = c_assignment_id
3064: and paaf.effective_end_date = (select max(effective_end_date)
3065: From per_assignments_f iipaf
3066: WHERE iipaf.assignment_id = c_assignment_id

Line 3156: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688800*/

3152: l_max_asg_action_id number; /*Bug 4040688*/
3153: l_max_action_sequence number; /*Bug 4040688*/
3154:
3155: l_payroll_id number; /*Bug 4688800*/
3156: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688800*/
3157:
3158: begin
3159:
3160: g_debug :=hr_utility.debug_enabled ;