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_PCSPS_PENSIONPAY dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

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

363: AND business_group_id=p_business_group_id; --New business group specific Condition is added in this cursor for bug 6856733
364:
365: --6666135 End
366:
367: --This cursor will check for the presence of assignments in pqp_assignment_attributes_f table
368: CURSOR c_pqp_assignment(n_assignment_id NUMBER)
369: IS
370: SELECT pqpaaf.lgps_process_flag,
371: pqpaaf.assignment_attribute_id,

Line 374: FROM pqp_assignment_attributes_f pqpaaf

370: SELECT pqpaaf.lgps_process_flag,
371: pqpaaf.assignment_attribute_id,
372: pqpaaf.EFFECTIVE_START_DATE,
373: pqpaaf.object_version_number
374: FROM pqp_assignment_attributes_f pqpaaf
375: WHERE pqpaaf.assignment_id = n_assignment_id
376: AND pqpaaf.business_group_id = p_business_group_id
377: 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
378: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE

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

375: WHERE pqpaaf.assignment_id = n_assignment_id
376: AND pqpaaf.business_group_id = p_business_group_id
377: 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
378: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE
379: OR pqpaaf.EFFECTIVE_START_DATE = (select min(EFFECTIVE_START_DATE) from pqp_assignment_attributes_f where assignment_id = n_assignment_id
380: AND lgps_process_flag = nvl(l_mode,lgps_process_flag) AND business_group_id = p_business_group_id
381: AND EFFECTIVE_START_DATE BETWEEN v_assignment_eff_date AND v_eff_end_date));
382:
383: --This cursor will fetch the all elements for the assigment

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

414: WHERE pet.element_type_id = n_element_type_id
415: AND pet.INFORMATION_TYPE = 'PQP_UK_ELEMENT_ATTRIBUTION';
416:
417:
418: --This cursor to check the future date track records in pqp_assignment_attributes_f
419: CURSOR c_future_date(n_assignment_id NUMBER)
420: IS
421: SELECT max(EFFECTIVE_START_DATE)
422: FROM pqp_assignment_attributes_f pqpaaf

Line 422: FROM pqp_assignment_attributes_f pqpaaf

418: --This cursor to check the future date track records in pqp_assignment_attributes_f
419: CURSOR c_future_date(n_assignment_id NUMBER)
420: IS
421: SELECT max(EFFECTIVE_START_DATE)
422: FROM pqp_assignment_attributes_f pqpaaf
423: WHERE pqpaaf.assignment_id = n_assignment_id
424: AND pqpaaf.business_group_id = p_business_group_id;
425: --
426: --This cursor to correct the entries till the end date

Line 430: FROM pqp_assignment_attributes_f pqpaaf

426: --This cursor to correct the entries till the end date
427: CURSOR c_correct_pqp(n_assignment_id NUMBER)
428: IS
429: SELECT ASSIGNMENT_ATTRIBUTE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, object_version_number
430: FROM pqp_assignment_attributes_f pqpaaf
431: WHERE pqpaaf.assignment_id = n_assignment_id
432: and pqpaaf.business_group_id = p_business_group_id
433: and pqpaaf.EFFECTIVE_START_DATE > v_max_date
434: -- and pqpaaf.EFFECTIVE_START_DATE between v_eff_start_date and v_eff_end_date_corr;

Line 468: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;

464: n_present number;
465: b_rate_type boolean;
466: b_element_present boolean;
467: b_input_value_present boolean;
468: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
469: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
470: l_lgps_pensionable_pay number;
471: b_pqp_assignment_found boolean;
472: b_pqp_found boolean;

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

465: b_rate_type boolean;
466: b_element_present boolean;
467: b_input_value_present boolean;
468: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
469: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
470: l_lgps_pensionable_pay number;
471: b_pqp_assignment_found boolean;
472: b_pqp_found boolean;
473: c_pqp_assignment_row c_pqp_assignment%rowtype;

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

656: END IF;
657: END IF;
658:
659: IF b_pqp_assignment_found is NULL AND l_mode is not null THEN
660: --No records in PQP_ASSIGNMENT_ATTRIBUTES_F table matching mode - reprocess or incomplete.
661:
662: hr_utility.trace('Skip assignment raised because of IF b_pqp_assignment_found is NULL AND l_mode is not null THEN');
663: raise skip_assignment;
664: END IF;

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

823: END IF;
824: ----------
825: ELSE
826: IF l_mode is null then
827: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';
828: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
829: END IF;
830: raise skip_assignment;
831: END IF; --b_pqp_assignment_found

Line 1059: FROM pqp_assignment_attributes_f pqaaf

1055: v_trans_flag varchar2(30);
1056: CURSOR C_Transtional_Flag
1057: IS
1058: SELECT LGPS_TRANS_ARRANG_FLAG
1059: FROM pqp_assignment_attributes_f pqaaf
1060: WHERE pqaaf.assignment_id = p_assignment_id
1061: AND pqaaf.business_group_id = p_business_group_id
1062: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
1063: BEGIN

Line 1077: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;

1073: p_effective_date Date,
1074: p_business_group_id NUMBER)
1075: RETURN number
1076: IS
1077: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
1078: CURSOR c_pension_pay
1079: IS
1080: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
1081: FROM pqp_assignment_attributes_f pqaaf

Line 1081: FROM pqp_assignment_attributes_f pqaaf

1077: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
1078: CURSOR c_pension_pay
1079: IS
1080: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
1081: FROM pqp_assignment_attributes_f pqaaf
1082: WHERE pqaaf.assignment_id = p_assignment_id
1083: AND pqaaf.business_group_id = p_business_group_id
1084: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
1085: BEGIN