APPS.PAY_GB_BACS_TAPE dependencies on PER_ASSIGNMENTS

Line 122: p_assignment_number per_assignments.ASSIGNMENT_NUMBER%TYPE;

118: block_count NUMBER;
119: org_payment_count NUMBER;
120: p_value NUMBER;
121: p_payroll_action_id NUMBER;
122: p_assignment_number per_assignments.ASSIGNMENT_NUMBER%TYPE;
123: p_personal_payment_method_id NUMBER;
124: p_org_payment_method_id NUMBER;
125: p_previous_payment_id NUMBER;
126: total_payment NUMBER;

Line 143: per_assignments pa

139: ppp.value,
140: pa.assignment_number
141: FROM pay_assignment_actions paa,
142: pay_pre_payments ppp,
143: per_assignments pa
144: WHERE paa.payroll_action_id = p_payroll_action_id
145: AND ppp.pre_payment_id = paa.pre_payment_id
146: AND paa.assignment_id = pa.assignment_id
147: ORDER BY ppp.org_payment_method_id, pa.assignment_number;

Line 674: per_assignments_f ASSIGN,

670: CURSOR payment_rule(param1 DATE, param2 NUMBER) IS
671: SELECT target.SEGMENT9
672: FROM hr_soft_coding_keyflex target,
673: fnd_id_flex_structures FNDID,
674: per_assignments_f ASSIGN,
675: pay_payrolls_f PAYROLL
676: WHERE param1 BETWEEN ASSIGN.effective_start_date
677: AND ASSIGN.effective_end_date
678: AND ASSIGN.assignment_id = param2