APPS.PAY_JP_ZENGIN_TAPE dependencies on PER_ASSIGNMENTS

Line 81: p_assignment_number per_assignments.ASSIGNMENT_NUMBER%TYPE;

77: block_count NUMBER;
78: org_payment_count NUMBER;
79: p_value NUMBER;
80: p_payroll_action_id NUMBER;
81: p_assignment_number per_assignments.ASSIGNMENT_NUMBER%TYPE;
82: p_personal_payment_method_id NUMBER;
83: p_org_payment_method_id NUMBER;
84: p_previous_payment_id NUMBER;
85: total_payment NUMBER;

Line 102: per_assignments pa

98: ppp.value,
99: pa.assignment_number
100: FROM pay_assignment_actions paa,
101: pay_pre_payments ppp,
102: per_assignments pa
103: WHERE paa.payroll_action_id = p_payroll_action_id
104: AND ppp.pre_payment_id = paa.pre_payment_id
105: AND paa.assignment_id = pa.assignment_id
106: ORDER BY ppp.org_payment_method_id, pa.assignment_number;

Line 605: per_assignments_f ASSIGN,

601: --
602: CURSOR payment_rule(param1 DATE, param2 NUMBER) IS
603: SELECT target.SEGMENT9
604: FROM hr_soft_coding_keyflex target,
605: per_assignments_f ASSIGN,
606: pay_payrolls_f PAYROLL
607: -- WHERE to_date (param1, 'DD-MON-YYYY')
608: WHERE fnd_date.canonical_to_date(param1)
609: BETWEEN ASSIGN.effective_start_date