APPS.HRBALDTM dependencies on PAY_PAYROLLS_F

Line 37: l_consol_set_id pay_payrolls_f.payroll_id%type;

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
41: --

Line 50: pay_payrolls_f PAYROLL

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
54: and PAYROLL.payroll_id = ASSIGN.payroll_id