DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1632: ,pay_personal_payment_methods_f ppm

1628: ,pop.currency_code
1629: FROM pay_external_accounts pea
1630: ,pay_pre_payments ppp
1631: ,pay_org_payment_methods_f pop
1632: ,pay_personal_payment_methods_f ppm
1633: WHERE ppp.assignment_action_id = p_curr_pymt_ass_act_id
1634: AND nvl(ppp.personal_payment_method_id,0) = nvl(p_personal_payment_method_id,0)
1635: AND ppp.org_payment_method_id = p_org_payment_method_id
1636: AND ppp.personal_payment_method_id = ppm.personal_payment_method_id (+)

Line 1680: l_percentage pay_personal_payment_methods_f.percentage%TYPE;

1676: l_bank_name pay_external_accounts.segment3%TYPE;
1677: l_bank_branch pay_external_accounts.segment4%TYPE;
1678: l_bank VARCHAR2(310);
1679: l_account_number pay_external_accounts.segment1%TYPE;
1680: l_percentage pay_personal_payment_methods_f.percentage%TYPE;
1681: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;
1682: l_prof_tax_number hr_organization_information.org_information1%TYPE;
1683: /*4229709*/
1684: l_emp_det_act_info_id NUMBER;