[Home] [Help]
137: SELECT ppp.org_payment_method_id,
138: ppp.personal_payment_method_id,
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
258: BEGIN
259: hr_utility.set_location('bacsmgtp.get_org_context',1);
260: SELECT ppp.org_payment_method_id
261: INTO p_org_payment_method_id
262: FROM pay_assignment_actions paa, pay_pre_payments ppp
263: WHERE paa.payroll_action_id = p_payroll_action_id
264: AND ppp.pre_payment_id = paa.pre_payment_id
265: AND ROWNUM = 1
266: ORDER BY ppp.org_payment_method_id;
568: return date is
569: --
570: CURSOR csr_get_default_date IS
571: select default_dd_date
572: from pay_assignment_actions paa,
573: pay_payroll_actions ppa,
574: per_time_periods ptp
575: where paa.assignment_action_id =
576: p_assignment_action_id
585: from per_time_period_rules tpr,
586: per_time_period_types tpt,
587: per_time_periods ptp,
588: pay_payroll_actions ppa,
589: pay_assignment_actions paa
590: where paa.assignment_action_id = p_assignment_action_id
591: and ppa.payroll_action_id = paa.payroll_action_id
592: and ptp.time_period_id = ppa.time_period_id
593: and ptp.period_type = tpt.period_type
642: --
643: CURSOR csr_get_details is
644: select paa.assignment_id, ppa.effective_date
645: from pay_payroll_actions ppa,
646: pay_assignment_actions paa
647: where paa.assignment_action_id = p_assignment_action_id
648: and ppa.payroll_action_id = paa.payroll_action_id;
649: --
650: CURSOR get_banks IS
650: CURSOR get_banks IS
651: select pea.segment8
652: from pay_org_payment_methods_f pop,
653: pay_personal_payment_methods_f ppp,
654: pay_assignment_actions paa,
655: pay_external_accounts pea,
656: pay_payment_types ppt
657: where paa.assignment_action_id =
658: p_assignment_action_id