[Home] [Help]
142: SELECT ppp.org_payment_method_id,
143: ppp.personal_payment_method_id,
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
263: BEGIN
264: hr_utility.set_location('bacsmgtp.get_org_context',1);
265: SELECT ppp.org_payment_method_id
266: INTO p_org_payment_method_id
267: FROM pay_assignment_actions paa, pay_pre_payments ppp
268: WHERE paa.payroll_action_id = p_payroll_action_id
269: AND ppp.pre_payment_id = paa.pre_payment_id
270: AND ROWNUM = 1
271: ORDER BY ppp.org_payment_method_id;
573: return date is
574: --
575: CURSOR csr_get_default_date IS
576: select default_dd_date
577: from pay_assignment_actions paa,
578: pay_payroll_actions ppa,
579: per_time_periods ptp
580: where paa.assignment_action_id =
581: p_assignment_action_id
590: from per_time_period_rules tpr,
591: per_time_period_types tpt,
592: per_time_periods ptp,
593: pay_payroll_actions ppa,
594: pay_assignment_actions paa
595: where paa.assignment_action_id = p_assignment_action_id
596: and ppa.payroll_action_id = paa.payroll_action_id
597: and ptp.time_period_id = ppa.time_period_id
598: and ptp.period_type = tpt.period_type
647: --
648: CURSOR csr_get_details is
649: select paa.assignment_id, ppa.effective_date
650: from pay_payroll_actions ppa,
651: pay_assignment_actions paa
652: where paa.assignment_action_id = p_assignment_action_id
653: and ppa.payroll_action_id = paa.payroll_action_id;
654: --
655: CURSOR get_banks IS
655: CURSOR get_banks IS
656: select pea.segment8
657: from pay_org_payment_methods_f pop,
658: pay_personal_payment_methods_f ppp,
659: pay_assignment_actions paa,
660: pay_external_accounts pea,
661: pay_payment_types ppt
662: where paa.assignment_action_id =
663: p_assignment_action_id