APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ALL_PAYROLLS_F

Line 6796: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

6792: l_payroll_id NUMBER(15);
6793: l_person_id NUMBER(15);
6794: l_organization_id NUMBER(15);
6795: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6796: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6797: l_full_name per_all_people_f.full_name%TYPE;
6798: l_organization_name hr_organization_units.name%TYPE;
6799: l_process_mode VARCHAR2(15);
6800: l_enc_begin_date DATE;

Line 6965: FROM pay_all_payrolls_f

6961: AND ROWNUM = 1;
6962:
6963: CURSOR payroll_name_cur IS
6964: SELECT payroll_name
6965: FROM pay_all_payrolls_f
6966: WHERE payroll_id = l_payroll_id
6967: AND business_group_id = g_business_group_id
6968: AND gl_set_of_books_id = g_set_of_books_id;
6969:

Line 8806: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

8802: l_payroll_id NUMBER(15);
8803: l_person_id NUMBER(15);
8804: l_organization_id NUMBER(15);
8805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8806: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8807: l_full_name per_all_people_f.full_name%TYPE;
8808: l_organization_name hr_organization_units.name%TYPE;
8809: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
8810: l_process_mode VARCHAR2(15);

Line 8882: FROM pay_all_payrolls_f

8878: AND ROWNUM = 1;
8879:
8880: CURSOR payroll_name_cur IS
8881: SELECT payroll_name
8882: FROM pay_all_payrolls_f
8883: WHERE payroll_id = p_payroll_id
8884: AND business_group_id = g_business_group_id
8885: AND gl_set_of_books_id = g_set_of_books_id
8886: AND ROWNUM = 1;