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_ARCHIVE dependencies on PAY_GB_FPS_DETAILS

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

18: 25-Jan-2013 rajganga 115.12 csr_director.
19: 07-FEB-2013 ssarap 115.111 16276411 Fix for Mckesson reported issues.
20: 08-FEB-2013 ssarap 115.11 16276411 Assignment number data type is modified.
21: 09-FEB-2013 ssarap 115.12 16276411 Validation logic change.
22: 12-FEB-2013 sampmand 115.13 16276411 Added logic to delete from pay_gb_fps_details in case of retry.
23: 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.
24: 14-FEB-2013 sampmand 115.18 16276411 Modified Tax Code Fetch logic to fix Mckesson issue.
25: Included 'TERM_ASSIGN' in get_eff_start_date cursor
26: to set first fps starter date correctly.

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

6663: select 'Y' from pay_payroll_actions ppa
6664: where c_payroll_id = pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID')
6665: and pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS') = 'Y'
6666: and ACTION_STATUS = 'C'
6667: and exists (select 1 from pay_gb_fps_details where PAYROLL_ACTION_ID = ppa.payroll_action_id);
6668:
6669: cursor csr_other_prepay_pactid(c_tax_ref varchar2) is
6670: select distinct ppa.payroll_action_id
6671: from pay_payroll_actions ppa

Line 7100: FROM pay_gb_fps_details pgfd

7096: (
7097: paa.assignment_action_id >
7098: (
7099: SELECT nvl (max (payroll_asg_act_id),paa.assignment_action_id)
7100: FROM pay_gb_fps_details pgfd
7101: WHERE pgfd.person_id = p_person_id
7102: )
7103: AND paa.source_action_id IS NULL
7104: )

Line 7108: FROM pay_gb_fps_details pgfd

7104: )
7105: OR (
7106: (
7107: SELECT count (*)
7108: FROM pay_gb_fps_details pgfd
7109: WHERE pgfd.person_id = p_person_id
7110: ) = 0
7111: )
7112: )

Line 7158: FROM pay_gb_fps_details pgfd

7154: (
7155: paa.assignment_action_id >
7156: (
7157: SELECT nvl (max (payroll_asg_act_id),paa.assignment_action_id)
7158: FROM pay_gb_fps_details pgfd
7159: WHERE pgfd.person_id = p_person_id
7160: -- AND pgfd.assignment_id = p_asg_id
7161: )
7162: AND paa.source_action_id IS NULL

Line 7167: FROM pay_gb_fps_details pgfd

7163: )
7164: OR (
7165: (
7166: SELECT count (*)
7167: FROM pay_gb_fps_details pgfd
7168: WHERE pgfd.person_id = p_person_id
7169: AND pgfd.assignment_id = p_asg_id
7170: ) = 0
7171: )

Line 7259: FROM pay_gb_fps_details pgfd

7255: and ppp.value <> 0); --For the bug 16542698
7256:
7257: CURSOR csr_chk_earlier_processed (c_person_id number, c_cur_asg_action_id number) is
7258: SELECT count (*)
7259: FROM pay_gb_fps_details pgfd
7260: WHERE pgfd.person_id = c_person_id
7261: AND pgfd.payroll_asg_act_id = c_cur_asg_action_id;
7262:
7263: --Below cursor fetches the latest payroll run details of the current assignment

Line 8904: FROM pay_gb_fps_details

8900: --Below cursor verifies whether current payment for this assignment is already archived
8901: CURSOR csr_earlier_archived(p_last_asg_action_id NUMBER)
8902: IS
8903: SELECT DISTINCT fps_asg_act_id
8904: FROM pay_gb_fps_details
8905: WHERE payroll_asg_act_id = p_last_asg_action_id;
8906:
8907: --Below cursor fetches the already archived record for this assignment
8908: CURSOR csr_get_archived_record(p_assignment_action_id NUMBER, p_act_info_cat VARCHAR2)

Line 9068: FROM pay_gb_fps_details pgfd

9064: (
9065: paa.assignment_action_id >
9066: (
9067: SELECT nvl (max (payroll_asg_act_id),paa.assignment_action_id)
9068: FROM pay_gb_fps_details pgfd
9069: WHERE pgfd.person_id = p_person_id
9070: )
9071: AND source_action_id IS NULL
9072: )

Line 9076: FROM pay_gb_fps_details pgfd

9072: )
9073: OR (
9074: (
9075: SELECT count (*)
9076: FROM pay_gb_fps_details pgfd
9077: WHERE pgfd.person_id = p_person_id
9078: ) = 0
9079: )
9080: )

Line 9199: 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

9195: ,ACTION_INFORMATION27
9196: ,ACTION_INFORMATION28
9197: ,ACTION_INFORMATION29
9198: ,ACTION_INFORMATION30
9199: 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
9200: and FPS_PAY_ACT_ID <> g_payroll_action_id) --= 9789749
9201: and ACTION_CONTEXT_TYPE = 'AAP' and
9202: ACTION_INFORMATION_CATEGORY in( 'GB_RTI_FPS_ASG_DET1', 'GB_RTI_FPS_ASG_DET2');
9203:

Line 9328: from PAY_GB_FPS_DETAILS

9324: c_asg_id number,
9325: c_cur_asg_action_id number) is
9326: select count(*)
9327: --into l_asg_act_processed_earlier
9328: from PAY_GB_FPS_DETAILS
9329: where PERSON_ID = c_person_id
9330: and ASSIGNMENT_ID = c_asg_id
9331: and PAYROLL_ASG_ACT_ID = c_cur_asg_action_id;
9332:

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

9897: end if; --l_retry_req_flag
9898:
9899: --RETRY Logic ends here
9900:
9901: --delete from pay_gb_fps_details in case of retry
9902: if l_retry_req_flag = 'Y' then
9903: hr_utility.trace('RETRY : l_retry_req_flag: '|| l_retry_req_flag);
9904: select payroll_action_id into l_pact_id
9905: from pay_assignment_actions where assignment_action_id = p_assactid;

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

9907: fetch get_min_asg_actid into min_asgactid;
9908: close get_min_asg_actid;
9909:
9910: if min_asgactid = p_assactid then
9911: hr_utility.trace('deleting form pay_gb_fps_details in case of retry ');
9912: delete from pay_gb_fps_details
9913: where person_ID = l_person_id
9914: and FPS_PAY_ACT_ID = l_pact_id;
9915: end if;

Line 9912: delete from pay_gb_fps_details

9908: close get_min_asg_actid;
9909:
9910: if min_asgactid = p_assactid then
9911: hr_utility.trace('deleting form pay_gb_fps_details in case of retry ');
9912: delete from pay_gb_fps_details
9913: where person_ID = l_person_id
9914: and FPS_PAY_ACT_ID = l_pact_id;
9915: end if;
9916: end if;

Line 10713: INTO PAY_GB_FPS_DETAILS

10709: FETCH csr_pay_act_details INTO l_payroll_pact_id;
10710: CLOSE csr_pay_act_details;
10711:
10712: INSERT
10713: INTO PAY_GB_FPS_DETAILS
10714: (
10715: ASSIGNMENT_ID,
10716: PERSON_ID,
10717: FPS_ASG_ACT_ID,

Line 11244: from PAY_GB_FPS_DETAILS

11240: if (l_archive_asg_det1 and l_archive_asg_det2) then
11241:
11242: select count(*)
11243: into l_rec_count
11244: from PAY_GB_FPS_DETAILS
11245: where ASSIGNMENT_ID = l_asg_id
11246: and PERSON_ID = l_person_id
11247: and PAYROLL_ASG_ACT_ID = l_cur_asg_action_id;
11248:

Line 11289: INTO PAY_GB_FPS_DETAILS

11285: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_cur_asg_pre_pay_act_id,60);
11286: end;
11287: */
11288: INSERT
11289: INTO PAY_GB_FPS_DETAILS
11290: (
11291: ASSIGNMENT_ID,
11292: PERSON_ID,
11293: FPS_ASG_ACT_ID,

Line 11666: from PAY_GB_FPS_DETAILS

11662: if (l_archive_asg_det1 and l_archive_asg_det2) then
11663:
11664: select count(*)
11665: into l_rec_count
11666: from PAY_GB_FPS_DETAILS
11667: where ASSIGNMENT_ID = l_cur_asg_id
11668: and PERSON_ID = l_person_id
11669: and PAYROLL_ASG_ACT_ID = l_cur_asg_action_id;
11670:

Line 11719: INTO PAY_GB_FPS_DETAILS

11715: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_cur_asg_pre_pay_act_id,60);
11716: end;
11717: */
11718: INSERT
11719: INTO PAY_GB_FPS_DETAILS
11720: (
11721: ASSIGNMENT_ID,
11722: PERSON_ID,
11723: FPS_ASG_ACT_ID,

Line 12146: from PAY_GB_FPS_DETAILS

12142: */
12143:
12144: /*select count(*)
12145: into l_rec_count
12146: from PAY_GB_FPS_DETAILS
12147: where ASSIGNMENT_ID = l_asg_id
12148: and PERSON_ID = l_person_id
12149: and PAYROLL_ASG_ACT_ID = l_last_asg_action_id;
12150:

Line 12158: INTO PAY_GB_FPS_DETAILS

12154: hr_utility.set_location('2 p_assactid: '||p_assactid,999);
12155: hr_utility.set_location('2 l_last_asg_action_id: '||l_last_asg_action_id,999);
12156: hr_utility.set_location('2 inserting',999);
12157: INSERT
12158: INTO PAY_GB_FPS_DETAILS
12159: (
12160: ASSIGNMENT_ID,
12161: PERSON_ID,
12162: FPS_ASG_ACT_ID,

Line 12477: INTO PAY_GB_FPS_DETAILS

12473: FETCH csr_pay_act_details INTO l_payroll_pact_id;
12474: CLOSE csr_pay_act_details;
12475:
12476: INSERT
12477: INTO PAY_GB_FPS_DETAILS
12478: (
12479: ASSIGNMENT_ID,
12480: PERSON_ID,
12481: FPS_ASG_ACT_ID,

Line 12982: INTO PAY_GB_FPS_DETAILS

12978:
12979: insert_archive_row_agg(p_assactid, p_effective_date,l_archive_tab_ni_rpt);
12980: insert_archive_row_agg(p_assactid, p_effective_date,l_archive_tab_det3);
12981: INSERT
12982: INTO PAY_GB_FPS_DETAILS
12983: (
12984: ASSIGNMENT_ID,
12985: PERSON_ID,
12986: FPS_ASG_ACT_ID,