eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 344: --This cursor will check for the presence of assignments in pqp_assignment_attributes_f table

340:
341: --6666135 End
342: --7369484 End
343:
344: --This cursor will check for the presence of assignments in pqp_assignment_attributes_f table
345: CURSOR c_pqp_assignment(n_assignment_id NUMBER)
346: IS
347: SELECT pqpaaf.lgps_process_flag,
348: pqpaaf.assignment_attribute_id,

Line 351: FROM pqp_assignment_attributes_f pqpaaf

347: SELECT pqpaaf.lgps_process_flag,
348: pqpaaf.assignment_attribute_id,
349: pqpaaf.EFFECTIVE_START_DATE,
350: pqpaaf.object_version_number
351: FROM pqp_assignment_attributes_f pqpaaf
352: WHERE pqpaaf.assignment_id = n_assignment_id
353: AND pqpaaf.business_group_id = p_business_group_id
354: AND nvl(pqpaaf.lgps_process_flag,'Nul') = nvl(l_mode,nvl(pqpaaf.lgps_process_flag,'Nul')) --l_mode will have value only in case of Incomplete and reprocess
355: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE

Line 356: OR pqpaaf.EFFECTIVE_START_DATE = (select min(EFFECTIVE_START_DATE) from pqp_assignment_attributes_f where assignment_id = n_assignment_id

352: WHERE pqpaaf.assignment_id = n_assignment_id
353: AND pqpaaf.business_group_id = p_business_group_id
354: AND nvl(pqpaaf.lgps_process_flag,'Nul') = nvl(l_mode,nvl(pqpaaf.lgps_process_flag,'Nul')) --l_mode will have value only in case of Incomplete and reprocess
355: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE
356: OR pqpaaf.EFFECTIVE_START_DATE = (select min(EFFECTIVE_START_DATE) from pqp_assignment_attributes_f where assignment_id = n_assignment_id
357: AND lgps_process_flag = nvl(l_mode,lgps_process_flag) AND business_group_id = p_business_group_id
358: AND EFFECTIVE_START_DATE BETWEEN v_assignment_eff_date AND v_eff_end_date));
359:
360: --This cursor will fetch the all elements for the assigment

Line 393: --This cursor to check the future date track records in pqp_assignment_attributes_f

389: WHERE pet.element_type_id = n_element_type_id
390: AND pet.INFORMATION_TYPE = 'PQP_UK_ELEMENT_ATTRIBUTION';
391:
392:
393: --This cursor to check the future date track records in pqp_assignment_attributes_f
394: CURSOR c_future_date(n_assignment_id NUMBER)
395: IS
396: SELECT max(EFFECTIVE_START_DATE)
397: FROM pqp_assignment_attributes_f pqpaaf

Line 397: FROM pqp_assignment_attributes_f pqpaaf

393: --This cursor to check the future date track records in pqp_assignment_attributes_f
394: CURSOR c_future_date(n_assignment_id NUMBER)
395: IS
396: SELECT max(EFFECTIVE_START_DATE)
397: FROM pqp_assignment_attributes_f pqpaaf
398: WHERE pqpaaf.assignment_id = n_assignment_id
399: AND pqpaaf.business_group_id = p_business_group_id;
400: --
401: --This cursor to correct the entries till the end date

Line 405: FROM pqp_assignment_attributes_f pqpaaf

401: --This cursor to correct the entries till the end date
402: CURSOR c_correct_pqp(n_assignment_id NUMBER)
403: IS
404: SELECT ASSIGNMENT_ATTRIBUTE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, object_version_number
405: FROM pqp_assignment_attributes_f pqpaaf
406: WHERE pqpaaf.assignment_id = n_assignment_id
407: and pqpaaf.business_group_id = p_business_group_id
408: and pqpaaf.EFFECTIVE_START_DATE > v_max_date
409: -- and pqpaaf.EFFECTIVE_START_DATE between v_eff_start_date and v_eff_end_date_corr;

Line 425: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;

421: n_present number;
422: b_rate_type boolean;
423: b_element_present boolean;
424: b_input_value_present boolean;
425: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
426: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
427: l_lgps_pensionable_pay number;
428: b_pqp_assignment_found boolean;
429: b_pqp_found boolean;

Line 426: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;

422: b_rate_type boolean;
423: b_element_present boolean;
424: b_input_value_present boolean;
425: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
426: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
427: l_lgps_pensionable_pay number;
428: b_pqp_assignment_found boolean;
429: b_pqp_found boolean;
430: c_pqp_assignment_row c_pqp_assignment%rowtype;

Line 614: --No records in PQP_ASSIGNMENT_ATTRIBUTES_F table matching mode - reprocess or incomplete.

610: END IF;
611: END IF;
612:
613: IF b_pqp_assignment_found is NULL AND l_mode is not null THEN
614: --No records in PQP_ASSIGNMENT_ATTRIBUTES_F table matching mode - reprocess or incomplete.
615: raise skip_assignment;
616: END IF;
617:
618: OPEN c1_all_element(c_all_assignments.assignment_id);

Line 764: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';

760: END IF;
761: ----------
762: ELSE
763: IF l_mode is null then
764: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';
765: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
766: END IF;
767: raise skip_assignment;
768: END IF; --b_pqp_assignment_found

Line 990: FROM pqp_assignment_attributes_f pqaaf

986: v_trans_flag varchar2(30);
987: CURSOR C_Transtional_Flag
988: IS
989: SELECT LGPS_TRANS_ARRANG_FLAG
990: FROM pqp_assignment_attributes_f pqaaf
991: WHERE pqaaf.assignment_id = p_assignment_id
992: AND pqaaf.business_group_id = p_business_group_id
993: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
994: BEGIN

Line 1006: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;

1002: p_effective_date Date,
1003: p_business_group_id NUMBER)
1004: RETURN number
1005: IS
1006: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
1007: CURSOR c_pension_pay
1008: IS
1009: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
1010: FROM pqp_assignment_attributes_f pqaaf

Line 1010: FROM pqp_assignment_attributes_f pqaaf

1006: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
1007: CURSOR c_pension_pay
1008: IS
1009: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
1010: FROM pqp_assignment_attributes_f pqaaf
1011: WHERE pqaaf.assignment_id = p_assignment_id
1012: AND pqaaf.business_group_id = p_business_group_id
1013: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
1014: BEGIN