[Home] [Help]
389: -- the GL CCID in the Import Sub-lines Process. Moreover the GLCCID will be obtained from
390: -- PSP_Clearing_Account table. (Decided by Venkat in 07/1998)
391: select a.GL_SET_OF_BOOKS_ID, Cost_Allocation_KeyFlex_ID
392: into n_Set_Of_Books_ID, n_Cost_Allocation_KeyFlex_ID
393: from PAY_PAYROLLS_F a
394: where a.PAYROLL_ID = v_Payroll_ID
395: and v_Effective_Date BETWEEN a.EFFECTIVE_START_DATE AND a.EFFECTIVE_END_DATE;
396:
397: v_Set_Of_Books_ID := fnd_Profile.Value('PSP_SET_OF_BOOKS');
397: v_Set_Of_Books_ID := fnd_Profile.Value('PSP_SET_OF_BOOKS');
398:
399: If (v_Set_Of_Books_ID IS NULL) or (to_number(v_Set_Of_Books_ID) <> n_Set_Of_Books_ID) Then
400: -- fnd_message.debug('Profile value for Set of Books ID :' || v_Set_Of_Books_ID || ' does not match
401: -- value from PAY_PAYROLLS_F. Cannot proceed');
402: return 23;
403: End If;
404:
405: -- Obtain Cost Allocation Key Flex ID, GL_Code_Combination_ID, and Balance_Amount using
467: ELSE
468: /***** Modifed the following SELECT for 11510_CU2 consolidated performance fixes.
469: Select DISTINCT a.payroll_id
470: into v_local_number
471: from pay_payrolls_f a, per_assignments_f b
472: where a.payroll_id = b.payroll_id
473: and a.PAYROLL_ID = v_Payroll_ID
474: and b.assignment_id = v_assignment_id
475: and (v_effective_date between a.effective_start_date and a.effective_end_date)
479:
480: -- Introduced the following for 11510_CU2 conslodated fixes.
481: SELECT a.payroll_id
482: INTO v_local_number
483: FROM pay_payrolls_f a
484: WHERE a.payroll_id = v_payroll_id
485: AND (v_effective_date between a.effective_start_date and a.effective_end_date)
486: AND a.business_group_id = v_business_group_id
487: AND a.gl_set_of_books_id = v_set_of_books_id
526: /* Commented for Bug : 14605283
527:
528: Select Cost_Allocation_KeyFlex_ID
529: into v_Cost_Allocation_Keyflex_ID
530: from PAY_PAYROLLS_F
531: where Payroll_ID = v_Payroll_Id
532: and v_Effective_Date between Effective_Start_Date and Effective_End_Date
533: and business_group_id = v_business_group_id
534: and gl_set_of_books_id = v_set_of_books_id;
562:
563: Select a.assignment_id
564: into v_local_number
565: from per_assignments_f a ,
566: pay_payrolls_f b
567: where a.person_id = v_person_id
568: AND a.assignment_type ='E' --Added for bug 2624259.
569: and a.assignment_id = v_Assignment_ID
570: and (v_effective_date between a.effective_start_date and a.effective_end_date)
595: WHERE a.Person_ID = v_person_id
596: -- AND a.current_employee_flag ='Y' --Added for bug 2624259. Commented for Bug 3424494
597: AND (v_effective_date BETWEEN a.EFFECTIVE_START_DATE and a.EFFECTIVE_END_DATE)
598: AND v_effective_date <= (SELECT max(b.effective_end_date)
599: FROM per_assignments_f b,pay_payrolls_f f
600: WHERE a.person_id = b.person_id
601: AND b.assignment_type ='E' --Added for bug 2624259.
602: AND b.business_group_id = v_business_group_id
603: AND f.gl_set_of_books_id = v_set_of_books_id
611: WHERE ppf.person_id = v_person_id
612: AND (v_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date)
613: AND v_effective_date <= (SELECT MAX(paf.effective_end_date)
614: FROM per_assignments_f paf,
615: pay_payrolls_f ppf2
616: WHERE paf.person_id = v_person_id
617: AND paf.business_group_id = v_business_group_id
618: AND ppf2.payroll_id = paf.payroll_id
619: AND paf.assignment_type ='E'
630: where a.Person_ID = v_Person_ID
631: and (v_effective_date BETWEEN a.EFFECTIVE_START_DATE and A.EFFECTIVE_END_DATE)
632: and a.business_group_id = v_business_group_id
633: and a.person_id in ( select distinct person_id
634: from per_assignments_f f,pay_payrolls_f b
635: where (v_effective_date between f.effective_start_date and f.effective_end_date)
636: and f.business_group_id = v_business_group_id
637: and b.gl_set_of_books_id = v_set_of_books_id
638: and f.payroll_id = b.payroll_id )