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.PAY_GB_RTI_FPS dependencies on PAY_GB_FPS_DETAILS

Line 147: 12-FEB-2013 sampmand 115.116 16276411 Added logic to delete from pay_gb_fps_details in case of retry.

143: 31-JAN-2013 krreddy 115.110 16164625 Modified to check if really payment made in current tax year.
144: 07-FEB-2013 ssarap 115.111 16276411 Fix for Mckesson reported issues.
145: 08-FEB-2013 ssarap 115.113 16276411 Assignment number data type is modified.
146: 09-FEB-2013 ssarap 115.114 16276411 NHS issues for validation.
147: 12-FEB-2013 sampmand 115.116 16276411 Added logic to delete from pay_gb_fps_details in case of retry.
148: 12-FEB-2013 ssarap 115.117 16310246 Changed the Action informatin column. For irre payemnt it is 3 and for one-off pay it is 4.
149: 14-FEB-2013 sampmand 115.118 16276411 Modified Tax Code Fetch logic to fix Mckesson issue.
150: Included 'TERM_ASSIGN' in get_eff_start_date cursor
151: to set first fps starter date correctly.

Line 6034: and exists (select 1 from pay_gb_fps_details where PAYROLL_ACTION_ID = ppa.payroll_action_id);

6030: select 'Y' from pay_payroll_actions ppa
6031: where c_payroll_id = pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID')
6032: and pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS') = 'Y'
6033: and ACTION_STATUS = 'C'
6034: and exists (select 1 from pay_gb_fps_details where PAYROLL_ACTION_ID = ppa.payroll_action_id);
6035:
6036: cursor csr_other_prepay_pactid(c_tax_ref varchar2) is
6037: select distinct ppa.payroll_action_id
6038: from pay_payroll_actions ppa

Line 6432: FROM pay_gb_fps_details pgfd

6428: (
6429: paa.assignment_action_id >
6430: (
6431: SELECT nvl (max (payroll_asg_act_id),paa.assignment_action_id)
6432: FROM pay_gb_fps_details pgfd
6433: WHERE pgfd.person_id = p_person_id
6434: )
6435: AND paa.source_action_id IS NULL
6436: )

Line 6440: FROM pay_gb_fps_details pgfd

6436: )
6437: OR (
6438: (
6439: SELECT count (*)
6440: FROM pay_gb_fps_details pgfd
6441: WHERE pgfd.person_id = p_person_id
6442: ) = 0
6443: )
6444: )

Line 6490: FROM pay_gb_fps_details pgfd

6486: (
6487: paa.assignment_action_id >
6488: (
6489: SELECT nvl (max (payroll_asg_act_id),paa.assignment_action_id)
6490: FROM pay_gb_fps_details pgfd
6491: WHERE pgfd.person_id = p_person_id
6492: -- AND pgfd.assignment_id = p_asg_id
6493: )
6494: AND paa.source_action_id IS NULL

Line 6499: FROM pay_gb_fps_details pgfd

6495: )
6496: OR (
6497: (
6498: SELECT count (*)
6499: FROM pay_gb_fps_details pgfd
6500: WHERE pgfd.person_id = p_person_id
6501: AND pgfd.assignment_id = p_asg_id
6502: ) = 0
6503: )

Line 6590: FROM pay_gb_fps_details pgfd

6586: and ppp.value <> 0); --For the bug 16542698
6587:
6588: CURSOR csr_chk_earlier_processed (c_person_id number, c_cur_asg_action_id number) is
6589: SELECT count (*)
6590: FROM pay_gb_fps_details pgfd
6591: WHERE pgfd.person_id = c_person_id
6592: AND pgfd.payroll_asg_act_id = c_cur_asg_action_id;
6593:
6594: --Below cursor fetches the latest payroll run details of the current assignment

Line 8270: FROM pay_gb_fps_details

8266: --Below cursor verifies whether current payment for this assignment is already archived
8267: CURSOR csr_earlier_archived(p_last_asg_action_id NUMBER)
8268: IS
8269: SELECT DISTINCT fps_asg_act_id
8270: FROM pay_gb_fps_details
8271: WHERE payroll_asg_act_id = p_last_asg_action_id;
8272:
8273: --Below cursor fetches the already archived record for this assignment
8274: CURSOR csr_get_archived_record(p_assignment_action_id NUMBER, p_act_info_cat VARCHAR2)

Line 8434: FROM pay_gb_fps_details pgfd

8430: (
8431: paa.assignment_action_id >
8432: (
8433: SELECT nvl (max (payroll_asg_act_id),paa.assignment_action_id)
8434: FROM pay_gb_fps_details pgfd
8435: WHERE pgfd.person_id = p_person_id
8436: )
8437: AND source_action_id IS NULL
8438: )

Line 8442: FROM pay_gb_fps_details pgfd

8438: )
8439: OR (
8440: (
8441: SELECT count (*)
8442: FROM pay_gb_fps_details pgfd
8443: WHERE pgfd.person_id = p_person_id
8444: ) = 0
8445: )
8446: )

Line 8564: from pay_action_information where action_context_id = (select max(FPS_ASG_ACT_ID) from pay_gb_fps_details where assignment_id = c_asg_id

8560: ,ACTION_INFORMATION27
8561: ,ACTION_INFORMATION28
8562: ,ACTION_INFORMATION29
8563: ,ACTION_INFORMATION30
8564: from pay_action_information where action_context_id = (select max(FPS_ASG_ACT_ID) from pay_gb_fps_details where assignment_id = c_asg_id
8565: and FPS_PAY_ACT_ID <> g_payroll_action_id) --= 9789749
8566: and ACTION_CONTEXT_TYPE = 'AAP' and
8567: ACTION_INFORMATION_CATEGORY in( 'GB_RTI_FPS_ASG_DET1', 'GB_RTI_FPS_ASG_DET2');
8568:

Line 8693: from PAY_GB_FPS_DETAILS

8689: c_asg_id number,
8690: c_cur_asg_action_id number) is
8691: select count(*)
8692: --into l_asg_act_processed_earlier
8693: from PAY_GB_FPS_DETAILS
8694: where PERSON_ID = c_person_id
8695: and ASSIGNMENT_ID = c_asg_id
8696: and PAYROLL_ASG_ACT_ID = c_cur_asg_action_id;
8697:

Line 9254: --delete from pay_gb_fps_details in case of retry

9250: end if; --l_retry_req_flag
9251:
9252: --RETRY Logic ends here
9253:
9254: --delete from pay_gb_fps_details in case of retry
9255: if l_retry_req_flag = 'Y' then
9256: hr_utility.trace('RETRY : l_retry_req_flag: '|| l_retry_req_flag);
9257: select payroll_action_id into l_pact_id
9258: from pay_assignment_actions where assignment_action_id = p_assactid;

Line 9264: hr_utility.trace('deleting form pay_gb_fps_details in case of retry ');

9260: fetch get_min_asg_actid into min_asgactid;
9261: close get_min_asg_actid;
9262:
9263: if min_asgactid = p_assactid then
9264: hr_utility.trace('deleting form pay_gb_fps_details in case of retry ');
9265: delete from pay_gb_fps_details
9266: where person_ID = l_person_id
9267: and FPS_PAY_ACT_ID = l_pact_id;
9268: end if;

Line 9265: delete from pay_gb_fps_details

9261: close get_min_asg_actid;
9262:
9263: if min_asgactid = p_assactid then
9264: hr_utility.trace('deleting form pay_gb_fps_details in case of retry ');
9265: delete from pay_gb_fps_details
9266: where person_ID = l_person_id
9267: and FPS_PAY_ACT_ID = l_pact_id;
9268: end if;
9269: end if;

Line 10036: INTO PAY_GB_FPS_DETAILS

10032: FETCH csr_pay_act_details INTO l_payroll_pact_id;
10033: CLOSE csr_pay_act_details;
10034:
10035: INSERT
10036: INTO PAY_GB_FPS_DETAILS
10037: (
10038: ASSIGNMENT_ID,
10039: PERSON_ID,
10040: FPS_ASG_ACT_ID,

Line 10553: from PAY_GB_FPS_DETAILS

10549: if (l_archive_asg_det1 and l_archive_asg_det2) then
10550:
10551: select count(*)
10552: into l_rec_count
10553: from PAY_GB_FPS_DETAILS
10554: where ASSIGNMENT_ID = l_asg_id
10555: and PERSON_ID = l_person_id
10556: and PAYROLL_ASG_ACT_ID = l_cur_asg_action_id;
10557:

Line 10598: INTO PAY_GB_FPS_DETAILS

10594: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_cur_asg_pre_pay_act_id,60);
10595: end;
10596: */
10597: INSERT
10598: INTO PAY_GB_FPS_DETAILS
10599: (
10600: ASSIGNMENT_ID,
10601: PERSON_ID,
10602: FPS_ASG_ACT_ID,

Line 10959: from PAY_GB_FPS_DETAILS

10955: if (l_archive_asg_det1 and l_archive_asg_det2) then
10956:
10957: select count(*)
10958: into l_rec_count
10959: from PAY_GB_FPS_DETAILS
10960: where ASSIGNMENT_ID = l_cur_asg_id
10961: and PERSON_ID = l_person_id
10962: and PAYROLL_ASG_ACT_ID = l_cur_asg_action_id;
10963:

Line 11012: INTO PAY_GB_FPS_DETAILS

11008: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_cur_asg_pre_pay_act_id,60);
11009: end;
11010: */
11011: INSERT
11012: INTO PAY_GB_FPS_DETAILS
11013: (
11014: ASSIGNMENT_ID,
11015: PERSON_ID,
11016: FPS_ASG_ACT_ID,

Line 11430: from PAY_GB_FPS_DETAILS

11426: */
11427:
11428: /*select count(*)
11429: into l_rec_count
11430: from PAY_GB_FPS_DETAILS
11431: where ASSIGNMENT_ID = l_asg_id
11432: and PERSON_ID = l_person_id
11433: and PAYROLL_ASG_ACT_ID = l_last_asg_action_id;
11434:

Line 11442: INTO PAY_GB_FPS_DETAILS

11438: hr_utility.set_location('2 p_assactid: '||p_assactid,999);
11439: hr_utility.set_location('2 l_last_asg_action_id: '||l_last_asg_action_id,999);
11440: hr_utility.set_location('2 inserting',999);
11441: INSERT
11442: INTO PAY_GB_FPS_DETAILS
11443: (
11444: ASSIGNMENT_ID,
11445: PERSON_ID,
11446: FPS_ASG_ACT_ID,

Line 11747: INTO PAY_GB_FPS_DETAILS

11743: FETCH csr_pay_act_details INTO l_payroll_pact_id;
11744: CLOSE csr_pay_act_details;
11745:
11746: INSERT
11747: INTO PAY_GB_FPS_DETAILS
11748: (
11749: ASSIGNMENT_ID,
11750: PERSON_ID,
11751: FPS_ASG_ACT_ID,

Line 12243: INTO PAY_GB_FPS_DETAILS

12239:
12240:
12241: insert_archive_row_agg(p_assactid, p_effective_date,l_archive_tab_ni_rpt);
12242: INSERT
12243: INTO PAY_GB_FPS_DETAILS
12244: (
12245: ASSIGNMENT_ID,
12246: PERSON_ID,
12247: FPS_ASG_ACT_ID,