APPS.PAY_BEE_UPGRADE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 67: per_all_assignments_f asg

63: pbl.assignment_number,
64: pbl.batch_line_status
65: FROM pay_batch_lines pbl,
66: pay_batch_headers pbh,
67: per_all_assignments_f asg
68: WHERE pbh.business_group_id = p_bg_id
69: AND pbl.assignment_id is null
70: AND asg.assignment_id = p_assignment_id
71: AND asg.business_group_id = p_bg_id

Line 108: from per_all_assignments_f asg

104: AND pbl.assignment_id is null
105: AND (pbl.assignment_number is null or
106: not exists
107: (select null
108: from per_all_assignments_f asg
109: where asg.assignment_id = p_assignment_id
110: and asg.business_group_id = p_bg_id
111: and upper(pbl.assignment_number) = upper(asg.assignment_number)
112: and pbl.effective_date between asg.effective_start_date and asg.effective_end_date))

Line 727: L_ASG_ID per_all_assignments_f.assignment_id%TYPE := P_ASG_ID;

723: and pbg.business_group_id = pct.business_group_id;
724: --
725: l_chunk_number pay_temp_object_actions.chunk_number%TYPE;
726: --
727: L_ASG_ID per_all_assignments_f.assignment_id%TYPE := P_ASG_ID;
728: L_BG_ID per_all_assignments_f.business_group_id%TYPE NULL;
729: L_LEG_CODE per_business_groups.legislation_code%TYPE := NULL;
730: L_PCT_ID pay_payroll_actions.payroll_action_id%TYPE := NULL;
731: --

Line 728: L_BG_ID per_all_assignments_f.business_group_id%TYPE NULL;

724: --
725: l_chunk_number pay_temp_object_actions.chunk_number%TYPE;
726: --
727: L_ASG_ID per_all_assignments_f.assignment_id%TYPE := P_ASG_ID;
728: L_BG_ID per_all_assignments_f.business_group_id%TYPE NULL;
729: L_LEG_CODE per_business_groups.legislation_code%TYPE := NULL;
730: L_PCT_ID pay_payroll_actions.payroll_action_id%TYPE := NULL;
731: --
732: cursor csr_max_chunck_num (p_pct_id number) is