APPS.PAY_NL_PAYFILE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 33: FROM pay_personal_payment_methods_f ppm

29: ) RETURN VARCHAR2 IS
30: --
31: CURSOR csr_get_payee_type_id IS
32: SELECT payee_type,payee_id
33: FROM pay_personal_payment_methods_f ppm
34: WHERE ppm.assignment_id = p_assignment_id
35: AND ppm.personal_payment_method_id = p_per_pay_method_id
36: AND p_date_earned BETWEEN ppm.effective_start_date
37: AND ppm.effective_end_date

Line 41: cursor csr_org_count (p_org_id pay_personal_payment_methods_f.payee_id%TYPE) is

37: AND ppm.effective_end_date
38: AND ppm.business_group_id = p_business_group_id
39: AND ppm.payee_id is NOT NULL;
40: --
41: cursor csr_org_count (p_org_id pay_personal_payment_methods_f.payee_id%TYPE) is
42: select count(*) from
43: hr_All_organization_units hou,
44: hr_organization_information hoi
45: where hou.organization_id = p_org_id

Line 51: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;

47: and hoi.org_information_context = 'CLASS'
48: and hoi.org_information1 = 'NL_PAYEE_OVERRIDE'
49: and hoi.org_information2='Y';
50: --
51: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;
52: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
53: l_payee_name VARCHAR(35);
54: l_org_count NUMBER;
55: --

Line 52: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;

48: and hoi.org_information1 = 'NL_PAYEE_OVERRIDE'
49: and hoi.org_information2='Y';
50: --
51: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;
52: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
53: l_payee_name VARCHAR(35);
54: l_org_count NUMBER;
55: --
56: l_inputs ff_exec.inputs_t;