APPS.HRBALDTM dependencies on PER_ASSIGNMENTS_F

Line 36: l_payroll_id per_assignments_f.payroll_id%type;

32: p_assignment_id in number,
33: p_date in date,
34: p_ass_action_id out number
35: )is
36: l_payroll_id per_assignments_f.payroll_id%type;
37: l_consol_set_id pay_payrolls_f.payroll_id%type;
38: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
39: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
40: begin

Line 49: from per_assignments_f ASSIGN,

45: select ASSIGN.payroll_id,
46: PAYROLL.consolidation_set_id
47: into l_payroll_id,
48: l_consol_set_id
49: from per_assignments_f ASSIGN,
50: pay_payrolls_f PAYROLL
51: where ASSIGN.assignment_id = p_assignment_id
52: and p_date between ASSIGN.effective_start_date
53: and ASSIGN.effective_end_date