APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ALL_PAYROLLS_F

Line 6539: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

6535: l_payroll_id NUMBER(15);
6536: l_person_id NUMBER(15);
6537: l_organization_id NUMBER(15);
6538: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6539: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6540: l_full_name per_all_people_f.full_name%TYPE;
6541: l_organization_name hr_organization_units.name%TYPE;
6542: l_process_mode VARCHAR2(15);
6543: l_enc_begin_date DATE;

Line 6688: FROM pay_all_payrolls_f

6684: AND ROWNUM = 1;
6685:
6686: CURSOR payroll_name_cur IS
6687: SELECT payroll_name
6688: FROM pay_all_payrolls_f
6689: WHERE payroll_id = l_payroll_id
6690: AND business_group_id = g_business_group_id
6691: AND gl_set_of_books_id = g_set_of_books_id;
6692:

Line 8483: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

8479: l_payroll_id NUMBER(15);
8480: l_person_id NUMBER(15);
8481: l_organization_id NUMBER(15);
8482: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8483: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8484: l_full_name per_all_people_f.full_name%TYPE;
8485: l_organization_name hr_organization_units.name%TYPE;
8486: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
8487: l_process_mode VARCHAR2(15);

Line 8558: FROM pay_all_payrolls_f

8554: AND ROWNUM = 1;
8555:
8556: CURSOR payroll_name_cur IS
8557: SELECT payroll_name
8558: FROM pay_all_payrolls_f
8559: WHERE payroll_id = p_payroll_id
8560: AND business_group_id = g_business_group_id
8561: AND gl_set_of_books_id = g_set_of_books_id
8562: AND ROWNUM = 1;