APPS.PAY_GB_BACS_TAPE dependencies on PER_ASSIGNMENTS

Line 127: p_assignment_number per_assignments.ASSIGNMENT_NUMBER%TYPE;

123: block_count NUMBER;
124: org_payment_count NUMBER;
125: p_value NUMBER;
126: p_payroll_action_id NUMBER;
127: p_assignment_number per_assignments.ASSIGNMENT_NUMBER%TYPE;
128: p_personal_payment_method_id NUMBER;
129: p_org_payment_method_id NUMBER;
130: p_previous_payment_id NUMBER;
131: total_payment NUMBER;

Line 148: per_assignments pa

144: ppp.value,
145: pa.assignment_number
146: FROM pay_assignment_actions paa,
147: pay_pre_payments ppp,
148: per_assignments pa
149: WHERE paa.payroll_action_id = p_payroll_action_id
150: AND ppp.pre_payment_id = paa.pre_payment_id
151: AND paa.assignment_id = pa.assignment_id
152: ORDER BY ppp.org_payment_method_id, pa.assignment_number;

Line 679: per_assignments_f ASSIGN,

675: CURSOR payment_rule(param1 DATE, param2 NUMBER) IS
676: SELECT target.SEGMENT9
677: FROM hr_soft_coding_keyflex target,
678: fnd_id_flex_structures FNDID,
679: per_assignments_f ASSIGN,
680: pay_payrolls_f PAYROLL
681: WHERE param1 BETWEEN ASSIGN.effective_start_date
682: AND ASSIGN.effective_end_date
683: AND ASSIGN.assignment_id = param2