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 331: --This cursor will check for the presence of assignments in pqp_assignment_attributes_f table

327:
328: --6666135 End
329: --7369484 End
330:
331: --This cursor will check for the presence of assignments in pqp_assignment_attributes_f table
332: CURSOR c_pqp_assignment(n_assignment_id NUMBER)
333: IS
334: SELECT pqpaaf.lgps_process_flag,
335: pqpaaf.assignment_attribute_id,

Line 338: FROM pqp_assignment_attributes_f pqpaaf

334: SELECT pqpaaf.lgps_process_flag,
335: pqpaaf.assignment_attribute_id,
336: pqpaaf.EFFECTIVE_START_DATE,
337: pqpaaf.object_version_number
338: FROM pqp_assignment_attributes_f pqpaaf
339: WHERE pqpaaf.assignment_id = n_assignment_id
340: AND pqpaaf.business_group_id = p_business_group_id
341: 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
342: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE

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

339: WHERE pqpaaf.assignment_id = n_assignment_id
340: AND pqpaaf.business_group_id = p_business_group_id
341: 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
342: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE
343: OR pqpaaf.EFFECTIVE_START_DATE = (select min(EFFECTIVE_START_DATE) from pqp_assignment_attributes_f where assignment_id = n_assignment_id
344: AND lgps_process_flag = nvl(l_mode,lgps_process_flag) AND business_group_id = p_business_group_id
345: AND EFFECTIVE_START_DATE BETWEEN v_assignment_eff_date AND v_eff_end_date));
346:
347: --This cursor will fetch the all elements for the assigment

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

375: WHERE pet.element_type_id = n_element_type_id
376: AND pet.INFORMATION_TYPE = 'PQP_UK_ELEMENT_ATTRIBUTION';
377:
378:
379: --This cursor to check the future date track records in pqp_assignment_attributes_f
380: CURSOR c_future_date(n_assignment_id NUMBER)
381: IS
382: SELECT max(EFFECTIVE_START_DATE)
383: FROM pqp_assignment_attributes_f pqpaaf

Line 383: FROM pqp_assignment_attributes_f pqpaaf

379: --This cursor to check the future date track records in pqp_assignment_attributes_f
380: CURSOR c_future_date(n_assignment_id NUMBER)
381: IS
382: SELECT max(EFFECTIVE_START_DATE)
383: FROM pqp_assignment_attributes_f pqpaaf
384: WHERE pqpaaf.assignment_id = n_assignment_id
385: AND pqpaaf.business_group_id = p_business_group_id;
386: --
387: --This cursor to correct the entries till the end date

Line 391: FROM pqp_assignment_attributes_f pqpaaf

387: --This cursor to correct the entries till the end date
388: CURSOR c_correct_pqp(n_assignment_id NUMBER)
389: IS
390: SELECT ASSIGNMENT_ATTRIBUTE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, object_version_number
391: FROM pqp_assignment_attributes_f pqpaaf
392: WHERE pqpaaf.assignment_id = n_assignment_id
393: and pqpaaf.business_group_id = p_business_group_id
394: and pqpaaf.EFFECTIVE_START_DATE > v_max_date
395: -- and pqpaaf.EFFECTIVE_START_DATE between v_eff_start_date and v_eff_end_date_corr;

Line 411: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;

407: n_present number;
408: b_rate_type boolean;
409: b_element_present boolean;
410: b_input_value_present boolean;
411: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
412: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
413: l_lgps_pensionable_pay number;
414: b_pqp_assignment_found boolean;
415: b_pqp_found boolean;

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

408: b_rate_type boolean;
409: b_element_present boolean;
410: b_input_value_present boolean;
411: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
412: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
413: l_lgps_pensionable_pay number;
414: b_pqp_assignment_found boolean;
415: b_pqp_found boolean;
416: c_pqp_assignment_row c_pqp_assignment%rowtype;

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

596: END IF;
597: END IF;
598:
599: IF b_pqp_assignment_found is NULL AND l_mode is not null THEN
600: --No records in PQP_ASSIGNMENT_ATTRIBUTES_F table matching mode - reprocess or incomplete.
601: raise skip_assignment;
602: END IF;
603:
604: OPEN c1_all_element(c_all_assignments.assignment_id);

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

746: END IF;
747: ----------
748: ELSE
749: IF l_mode is null then
750: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';
751: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
752: END IF;
753: raise skip_assignment;
754: END IF; --b_pqp_assignment_found

Line 971: FROM pqp_assignment_attributes_f pqaaf

967: v_trans_flag varchar2(30);
968: CURSOR C_Transtional_Flag
969: IS
970: SELECT LGPS_TRANS_ARRANG_FLAG
971: FROM pqp_assignment_attributes_f pqaaf
972: WHERE pqaaf.assignment_id = p_assignment_id
973: AND pqaaf.business_group_id = p_business_group_id
974: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
975: BEGIN

Line 987: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;

983: p_effective_date Date,
984: p_business_group_id NUMBER)
985: RETURN number
986: IS
987: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
988: CURSOR c_pension_pay
989: IS
990: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
991: FROM pqp_assignment_attributes_f pqaaf

Line 991: FROM pqp_assignment_attributes_f pqaaf

987: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
988: CURSOR c_pension_pay
989: IS
990: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
991: FROM pqp_assignment_attributes_f pqaaf
992: WHERE pqaaf.assignment_id = p_assignment_id
993: AND pqaaf.business_group_id = p_business_group_id
994: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
995: BEGIN