DBA Data[Home] [Help]

APPS.PAY_PAYUSNAC_XMLP_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 153: v_flag PAY_ORG_PAYMENT_METHODS_F.pmeth_information6%TYPE;

149: return ret;
150: end;
151:
152: function cf_bal_nachaformula(c_tot_amt in number) return number is
153: v_flag PAY_ORG_PAYMENT_METHODS_F.pmeth_information6%TYPE;
154: v_return NUMBER(12,2) := 0.00;
155: begin
156: begin
157: SELECT nvl(p1.pmeth_information6,'Y')

Line 159: FROM pay_org_payment_methods_f p1,

155: begin
156: begin
157: SELECT nvl(p1.pmeth_information6,'Y')
158: INTO v_flag
159: FROM pay_org_payment_methods_f p1,
160: pay_payroll_actions p2
161: WHERE p1.business_group_id = P_BUSINESS_GROUP_ID
162: AND p2.payroll_action_id = P_PAYROLL_ACTION_ID
163: AND p1.business_group_id = p2.business_group_id