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.HR_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 251: from per_business_groups

247: --start changes for bug 7217475
248:
249: cursor csr_chk_bg_exists is
250: select 1
251: from per_business_groups
252: where business_group_id = p_business_group_id;
253:
254: cursor csr_chk_person_exists is
255: select 1

Line 729: from per_business_groups

725: --start changes for bug 7217475
726:
727: cursor csr_chk_bg_exists is
728: select 1
729: from per_business_groups
730: where business_group_id = p_business_group_id;
731:
732: cursor csr_chk_person_exists is
733: select 1

Line 1328: per_business_groups_perf pgr

1324: --
1325: cursor csr_scl_idsel is
1326: select plr.rule_mode id_flex_num
1327: from pay_legislation_rules plr,
1328: per_business_groups_perf pgr
1329: where plr.legislation_code = pgr.legislation_code
1330: and pgr.business_group_id = p_business_group_id
1331: and plr.rule_type = 'S'
1332: and exists

Line 2159: l_legislation_code per_business_groups.legislation_code%TYPE;

2155: l_last_standard_process_date
2156: per_periods_of_service.last_standard_process_date%TYPE;
2157: l_actual_termination_date
2158: per_periods_of_service.actual_termination_date%TYPE;
2159: l_legislation_code per_business_groups.legislation_code%TYPE;
2160: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2161: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2162: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2163: l_proc varchar2(72)

Line 2175: , per_business_groups_perf bus

2171: , asg.primary_flag
2172: , bus.business_group_id
2173: , bus.legislation_code
2174: from per_all_assignments_f asg
2175: , per_business_groups_perf bus
2176: where asg.assignment_id = p_assignment_id
2177: and l_actual_termination_date between asg.effective_start_date
2178: and asg.effective_end_date
2179: and bus.business_group_id+0 = asg.business_group_id;

Line 3075: l_legislation_code per_business_groups.legislation_code%TYPE;

3071: l_last_standard_process_date
3072: per_periods_of_service.last_standard_process_date%TYPE;
3073: l_actual_termination_date
3074: per_periods_of_service.actual_termination_date%TYPE;
3075: l_legislation_code per_business_groups.legislation_code%TYPE;
3076: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
3077: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3078: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
3079: l_proc varchar2(72)

Line 3091: , per_business_groups_perf bus

3087: , asg.primary_flag
3088: , bus.business_group_id
3089: , bus.legislation_code
3090: from per_all_assignments_f asg
3091: , per_business_groups_perf bus
3092: where asg.assignment_id = p_assignment_id
3093: and l_actual_termination_date between asg.effective_start_date
3094: and asg.effective_end_date
3095: and bus.business_group_id+0 = asg.business_group_id;

Line 3642: l_business_group_id per_business_groups.business_group_id%TYPE;

3638: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3639: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3640: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3641: --
3642: l_business_group_id per_business_groups.business_group_id%TYPE;
3643: l_legislation_code per_business_groups.legislation_code%TYPE;
3644: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3645: l_proc varchar2(72);
3646: l_session_id number;

Line 3643: l_legislation_code per_business_groups.legislation_code%TYPE;

3639: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3640: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3641: --
3642: l_business_group_id per_business_groups.business_group_id%TYPE;
3643: l_legislation_code per_business_groups.legislation_code%TYPE;
3644: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3645: l_proc varchar2(72);
3646: l_session_id number;
3647: l_cagr_grade_def_id number;

Line 4514: l_business_group_id per_business_groups.business_group_id%TYPE;

4510: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4511: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4512: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4513: --
4514: l_business_group_id per_business_groups.business_group_id%TYPE;
4515: l_legislation_code per_business_groups.legislation_code%TYPE;
4516: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4517: l_proc varchar2(72) := g_package||
4518: 'create_secondary_emp_asg';

Line 4515: l_legislation_code per_business_groups.legislation_code%TYPE;

4511: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4512: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4513: --
4514: l_business_group_id per_business_groups.business_group_id%TYPE;
4515: l_legislation_code per_business_groups.legislation_code%TYPE;
4516: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4517: l_proc varchar2(72) := g_package||
4518: 'create_secondary_emp_asg';
4519: l_session_id number;

Line 4963: l_business_group_id per_business_groups.business_group_id%TYPE;

4959: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4960: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4961: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4962: --
4963: l_business_group_id per_business_groups.business_group_id%TYPE;
4964: l_legislation_code per_business_groups.legislation_code%TYPE;
4965: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4966: l_proc varchar2(72) := g_package||
4967: 'create_secondary_emp_asg';

Line 4964: l_legislation_code per_business_groups.legislation_code%TYPE;

4960: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4961: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4962: --
4963: l_business_group_id per_business_groups.business_group_id%TYPE;
4964: l_legislation_code per_business_groups.legislation_code%TYPE;
4965: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4966: l_proc varchar2(72) := g_package||
4967: 'create_secondary_emp_asg';
4968: l_session_id number;

Line 5077: , per_business_groups_perf bus

5073: cursor csr_get_derived_details is
5074: select bus.business_group_id
5075: , bus.legislation_code
5076: from per_all_people_f per
5077: , per_business_groups_perf bus
5078: where per.person_id = p_person_id
5079: and l_effective_date between per.effective_start_date
5080: and per.effective_end_date
5081: and bus.business_group_id = per.business_group_id;

Line 5101: from per_business_groups_perf

5097: -- (grp keyflex) for the specified business group
5098: --
5099: cursor csr_grp_idsel is
5100: select people_group_structure
5101: from per_business_groups_perf
5102: where business_group_id = l_business_group_id;
5103: --
5104: --
5105: -- the cursor csr_scl_idsel selects the valid id_flex_num

Line 6482: l_business_group_id per_business_groups.business_group_id%TYPE;

6478: l_comment_id per_all_assignments_f.comment_id%TYPE;
6479: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
6480: l_group_name pay_people_groups.group_name%TYPE;
6481: l_session_id NUMBER;
6482: l_business_group_id per_business_groups.business_group_id%TYPE;
6483: l_legislation_code per_business_groups.legislation_code%TYPE;
6484: l_pop_date_start DATE;
6485: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
6486: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 6483: l_legislation_code per_business_groups.legislation_code%TYPE;

6479: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
6480: l_group_name pay_people_groups.group_name%TYPE;
6481: l_session_id NUMBER;
6482: l_business_group_id per_business_groups.business_group_id%TYPE;
6483: l_legislation_code per_business_groups.legislation_code%TYPE;
6484: l_pop_date_start DATE;
6485: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
6486: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6487: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 6504: , per_business_groups_perf bus

6500: cursor csr_get_derived_details is
6501: select bus.business_group_id
6502: , bus.legislation_code
6503: from per_all_people_f per
6504: , per_business_groups_perf bus
6505: where per.person_id = p_person_id
6506: and l_effective_date between per.effective_start_date
6507: and per.effective_end_date
6508: and bus.business_group_id = per.business_group_id;

Line 6524: from per_business_groups_perf

6520: -- (grp keyflex) for the specified business group
6521: --
6522: cursor csr_grp_idsel is
6523: select people_group_structure
6524: from per_business_groups_perf
6525: where business_group_id = l_business_group_id;
6526: --
6527: --
6528: -- the cursor csr_scl_idsel selects the valid id_flex_num

Line 7740: l_legislation_code per_business_groups.legislation_code%TYPE;

7736: --
7737: -- Assigned the value p_assignment_number for fix of #2823013
7738: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
7739: l_effective_date date;
7740: l_legislation_code per_business_groups.legislation_code%TYPE;
7741: l_proc varchar2(72);
7742: --
7743: -- Declare dummy variables
7744: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 7752: per_business_groups_perf pbg

7748: --
7749: cursor csr_legislation is
7750: select null
7751: from per_all_assignments_f paf,
7752: per_business_groups_perf pbg
7753: where paf.person_id = p_person_id
7754: and l_effective_date between paf.effective_start_date
7755: and paf.effective_end_date
7756: and pbg.business_group_id = paf.business_group_id

Line 8049: l_legislation_code per_business_groups.legislation_code%TYPE;

8045: --
8046: -- Assigned the value p_assignment_number for fix of #2823013
8047: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8048: l_effective_date date;
8049: l_legislation_code per_business_groups.legislation_code%TYPE;
8050: l_proc varchar2(72);
8051: --
8052: -- Declare dummy variables
8053: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 8061: per_business_groups_perf pbg

8057: --
8058: cursor csr_legislation is
8059: select null
8060: from per_all_assignments_f paf,
8061: per_business_groups_perf pbg
8062: where paf.person_id = p_person_id
8063: and l_effective_date between paf.effective_start_date
8064: and paf.effective_end_date
8065: and pbg.business_group_id = paf.business_group_id

Line 8374: l_business_group_id per_business_groups.business_group_id%TYPE;

8370: -- WWBUG 2539685
8371: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8372: l_effective_date date;
8373: --
8374: l_business_group_id per_business_groups.business_group_id%TYPE;
8375: l_legislation_code per_business_groups.legislation_code%TYPE;
8376: l_proc varchar2(72);
8377: --
8378: -- Declare cursors

Line 8375: l_legislation_code per_business_groups.legislation_code%TYPE;

8371: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8372: l_effective_date date;
8373: --
8374: l_business_group_id per_business_groups.business_group_id%TYPE;
8375: l_legislation_code per_business_groups.legislation_code%TYPE;
8376: l_proc varchar2(72);
8377: --
8378: -- Declare cursors
8379: --

Line 8383: per_business_groups_perf pbg

8379: --
8380: cursor csr_legislation is
8381: select null
8382: from per_all_assignments_f paf,
8383: per_business_groups_perf pbg
8384: where paf.person_id = p_person_id
8385: and l_effective_date between paf.effective_start_date
8386: and paf.effective_end_date
8387: and pbg.business_group_id = paf.business_group_id

Line 8707: l_business_group_id per_business_groups.business_group_id%TYPE;

8703: -- Assigned the value p_assignment_number for fix of #2823013
8704: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8705: l_effective_date date;
8706: --
8707: l_business_group_id per_business_groups.business_group_id%TYPE;
8708: l_legislation_code per_business_groups.legislation_code%TYPE;
8709: l_proc varchar2(72);
8710: --
8711: -- Declare cursors

Line 8708: l_legislation_code per_business_groups.legislation_code%TYPE;

8704: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8705: l_effective_date date;
8706: --
8707: l_business_group_id per_business_groups.business_group_id%TYPE;
8708: l_legislation_code per_business_groups.legislation_code%TYPE;
8709: l_proc varchar2(72);
8710: --
8711: -- Declare cursors
8712: --

Line 8716: per_business_groups_perf pbg

8712: --
8713: cursor csr_legislation is
8714: select null
8715: from per_all_assignments_f paf,
8716: per_business_groups_perf pbg
8717: where paf.person_id = p_person_id
8718: and l_effective_date between paf.effective_start_date
8719: and paf.effective_end_date
8720: and pbg.business_group_id = paf.business_group_id

Line 10203: l_business_group_id per_business_groups.business_group_id%TYPE;

10199: --
10200: -- Internal working variables
10201: --
10202: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
10203: l_business_group_id per_business_groups.business_group_id%TYPE;
10204: l_payroll_id_updated boolean;
10205: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10206: l_org_now_no_manager_warning boolean;
10207: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 10559: l_business_group_id per_business_groups.business_group_id%TYPE;

10555: --
10556: -- Internal working variables
10557: --
10558: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
10559: l_business_group_id per_business_groups.business_group_id%TYPE;
10560: l_payroll_id_updated boolean;
10561: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10562: l_org_now_no_manager_warning boolean;
10563: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 10673: per_business_groups_perf pgr

10669: --
10670: cursor csr_scl_idsel is
10671: select plr.rule_mode id_flex_num
10672: from pay_legislation_rules plr,
10673: per_business_groups_perf pgr
10674: where plr.legislation_code = pgr.legislation_code
10675: and pgr.business_group_id = l_business_group_id
10676: and plr.rule_type = 'S'
10677: and exists

Line 11897: l_business_group_id per_business_groups.business_group_id%TYPE;

11893: l_proc VARCHAR2(72) := g_package||'update_cwk_asg';
11894: l_effective_date DATE;
11895: l_projected_assignment_end DATE;
11896: l_organization_id per_all_assignments_f.organization_id%TYPE;
11897: l_business_group_id per_business_groups.business_group_id%TYPE;
11898: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11899: l_location_id per_all_assignments_f.location_id%TYPE;
11900: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11901: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;

Line 11946: per_business_groups_perf pgr

11942: --
11943: cursor csr_scl_idsel is
11944: select plr.rule_mode id_flex_num
11945: from pay_legislation_rules plr,
11946: per_business_groups_perf pgr
11947: where plr.legislation_code = pgr.legislation_code
11948: and pgr.business_group_id = l_business_group_id
11949: and plr.rule_type = 'CWK_S'
11950: and exists

Line 12854: l_legislation_code per_business_groups.legislation_code%TYPE;

12850: l_api_updating boolean;
12851: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12852: l_comment_id per_all_assignments_f.comment_id%TYPE;
12853: l_entries_changed varchar2(1);
12854: l_legislation_code per_business_groups.legislation_code%TYPE;
12855: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
12856: l_proc varchar2(72) :=
12857: g_package || 'update_cwk_asg_criteria';
12858: l_validation_end_date date;

Line 12873: from per_business_groups_perf bus

12869: --
12870:
12871: cursor csr_get_legislation_code is
12872: select bus.legislation_code
12873: from per_business_groups_perf bus
12874: where bus.business_group_id = l_business_group_id;
12875: --
12876: cursor csr_get_salary is
12877: select element_entry_id

Line 12886: from per_business_groups_perf bus

12882: effective_start_date and effective_end_date;
12883: --
12884: cursor csr_grp_idsel is
12885: select bus.people_group_structure
12886: from per_business_groups_perf bus
12887: where bus.business_group_id = l_business_group_id;
12888: --
12889: cursor get_sec_date_range is
12890: select asg.effective_start_date

Line 13743: l_legislation_code per_business_groups.legislation_code%TYPE;

13739: l_proc varchar2(72);
13740: l_effective_date date;
13741: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13742: l_concatenated_segments varchar2(2000);
13743: l_legislation_code per_business_groups.legislation_code%TYPE;
13744: l_cagr_concatenated_segments varchar2(300);
13745: l_cagr_grade_def_id number;
13746: --
13747: --

Line 13928: l_legislation_code per_business_groups.legislation_code%TYPE;

13924: l_proc varchar2(72);
13925: l_effective_date date;
13926: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13927: l_concatenated_segments varchar2(2000);
13928: l_legislation_code per_business_groups.legislation_code%TYPE;
13929: --
13930: cursor check_legislation
13931: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
13932: c_effective_date date

Line 13937: per_business_groups_perf bgp

13933: )
13934: is
13935: select bgp.legislation_code
13936: from per_all_assignments_f asg,
13937: per_business_groups_perf bgp
13938: where asg.business_group_id = bgp.business_group_id
13939: and asg.assignment_id = c_assignment_id
13940: and c_effective_date
13941: between effective_start_date and effective_end_date;

Line 14165: l_legislation_code per_business_groups.legislation_code%TYPE;

14161: l_proc varchar2(72);
14162: l_effective_date date;
14163: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
14164: l_concatenated_segments varchar2(2000);
14165: l_legislation_code per_business_groups.legislation_code%TYPE;
14166: --
14167: cursor check_legislation
14168: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
14169: c_effective_date date

Line 14174: per_business_groups_perf bgp

14170: )
14171: is
14172: select bgp.legislation_code
14173: from per_all_assignments_f asg,
14174: per_business_groups_perf bgp
14175: where asg.business_group_id = bgp.business_group_id
14176: and asg.assignment_id = c_assignment_id
14177: and c_effective_date
14178: between effective_start_date and effective_end_date;

Line 14400: l_legislation_code per_business_groups.legislation_code%TYPE;

14396: -- Declare cursors and local variables
14397: --
14398: l_proc varchar2(72);
14399: l_effective_date date;
14400: l_legislation_code per_business_groups.legislation_code%TYPE;
14401: l_cagr_grade_def_id number;
14402: l_cagr_concatenated_segments number;
14403:
14404: --

Line 14612: l_legislation_code per_business_groups.legislation_code%TYPE;

14608: -- Declare cursors and local variables
14609: --
14610: l_proc varchar2(72);
14611: l_effective_date date;
14612: l_legislation_code per_business_groups.legislation_code%TYPE;
14613:
14614: --
14615: cursor check_legislation
14616: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 14622: per_business_groups_perf bgp

14618: )
14619: is
14620: select bgp.legislation_code
14621: from per_all_assignments_f asg,
14622: per_business_groups_perf bgp
14623: where asg.business_group_id = bgp.business_group_id
14624: and asg.assignment_id = c_assignment_id
14625: and c_effective_date
14626: between effective_start_date and effective_end_date;

Line 14877: l_legislation_code per_business_groups.legislation_code%TYPE;

14873: -- Declare cursors and local variables
14874: --
14875: l_proc varchar2(72);
14876: l_effective_date date;
14877: l_legislation_code per_business_groups.legislation_code%TYPE;
14878: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
14879:
14880: --
14881: cursor check_legislation

Line 14888: per_business_groups_perf bgp

14884: )
14885: is
14886: select bgp.legislation_code
14887: from per_all_assignments_f asg,
14888: per_business_groups_perf bgp
14889: where asg.business_group_id = bgp.business_group_id
14890: and asg.assignment_id = c_assignment_id
14891: and c_effective_date
14892: between effective_start_date and effective_end_date;

Line 15146: l_legislation_code per_business_groups.legislation_code%TYPE;

15142: -- Declare cursors and local variables
15143: --
15144: l_proc varchar2(72);
15145: l_effective_date date;
15146: l_legislation_code per_business_groups.legislation_code%TYPE;
15147:
15148: --
15149: cursor check_legislation
15150: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 15156: per_business_groups_perf bgp

15152: )
15153: is
15154: select bgp.legislation_code
15155: from per_all_assignments_f asg,
15156: per_business_groups_perf bgp
15157: where asg.business_group_id = bgp.business_group_id
15158: and asg.assignment_id = c_assignment_id
15159: and c_effective_date
15160: between effective_start_date and effective_end_date;

Line 15628: l_legislation_code per_business_groups.legislation_code%TYPE;

15624: l_api_updating boolean;
15625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15626: l_comment_id per_all_assignments_f.comment_id%TYPE;
15627: l_entries_changed varchar2(1);
15628: l_legislation_code per_business_groups.legislation_code%TYPE;
15629: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15630: l_proc varchar2(72) :=
15631: g_package || 'update_emp_asg_criteria';
15632:

Line 15843: l_legislation_code per_business_groups.legislation_code%TYPE;

15839: l_api_updating boolean;
15840: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15841: l_comment_id per_all_assignments_f.comment_id%TYPE;
15842: l_entries_changed varchar2(1);
15843: l_legislation_code per_business_groups.legislation_code%TYPE;
15844: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15845: l_proc varchar2(72) :=
15846: g_package || 'update_emp_asg_criteria';
15847: l_validation_end_date date;

Line 15983: from per_business_groups_perf bus

15979: where people_group_id = l_people_group_id;
15980: --
15981: cursor csr_get_legislation_code is
15982: select bus.legislation_code
15983: from per_business_groups_perf bus
15984: where bus.business_group_id = l_business_group_id;
15985: --
15986: cursor csr_get_salary is
15987: select element_entry_id

Line 16008: from per_business_groups_perf bus

16004: -- end of fix for bug 4464072
16005: --
16006: cursor csr_grp_idsel is
16007: select bus.people_group_structure
16008: from per_business_groups_perf bus
16009: where bus.business_group_id = l_business_group_id;
16010: --
16011: cursor get_sec_date_range is
16012: select asg.effective_start_date

Line 17694: from per_business_groups_perf bus

17690: --
17691: --
17692: cursor csr_grp_idsel is
17693: select bus.people_group_structure
17694: from per_business_groups_perf bus
17695: where bus.business_group_id = l_business_group_id;
17696: --
17697: cursor csr_scl_idsel is
17698: select plr.rule_mode id_flex_num

Line 17700: per_business_groups_perf pgr

17696: --
17697: cursor csr_scl_idsel is
17698: select plr.rule_mode id_flex_num
17699: from pay_legislation_rules plr,
17700: per_business_groups_perf pgr
17701: where plr.legislation_code = pgr.legislation_code
17702: and pgr.business_group_id = l_business_group_id
17703: and plr.rule_type = 'S'
17704: and exists

Line 18414: -- per_business_groups_perf

18410: -- Added this additional check
18411: or p_scl_concat_segments <> hr_api.g_varchar2
18412: then
18413: -- gets flex num id from pay_legislation_rules and
18414: -- per_business_groups_perf
18415: --
18416: open csr_scl_idsel;
18417: fetch csr_scl_idsel into l_flex_num;
18418: --

Line 19248: l_business_group_id per_business_groups.business_group_id%TYPE;

19244: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
19245: --
19246: -- Internal working variables
19247: --
19248: l_business_group_id per_business_groups.business_group_id%TYPE;
19249: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
19250: l_group_name pay_people_groups.group_name%TYPE;
19251: l_proc varchar2(72);
19252: l_api_updating boolean;

Line 19962: l_business_group_id per_business_groups.business_group_id%TYPE;

19958: l_group_name pay_people_groups.group_name%TYPE;
19959: l_old_group_name pay_people_groups.group_name%TYPE;
19960: --
19961: l_application_id per_applications.application_id%TYPE;
19962: l_business_group_id per_business_groups.business_group_id%TYPE;
19963: l_legislation_code per_business_groups.legislation_code%TYPE;
19964: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
19965: l_proc varchar2(72) := g_package||'create_secondary_apl_asg';
19966: l_effective_date date;

Line 19963: l_legislation_code per_business_groups.legislation_code%TYPE;

19959: l_old_group_name pay_people_groups.group_name%TYPE;
19960: --
19961: l_application_id per_applications.application_id%TYPE;
19962: l_business_group_id per_business_groups.business_group_id%TYPE;
19963: l_legislation_code per_business_groups.legislation_code%TYPE;
19964: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
19965: l_proc varchar2(72) := g_package||'create_secondary_apl_asg';
19966: l_effective_date date;
19967: l_date_probation_end date;

Line 20086: , per_business_groups_perf bus

20082: select bus.business_group_id
20083: , bus.legislation_code
20084: , per.applicant_number, per.object_version_number --3652025
20085: from per_all_people_f per
20086: , per_business_groups_perf bus
20087: where per.person_id = p_person_id
20088: and l_effective_date between per.effective_start_date
20089: and per.effective_end_date
20090: and bus.business_group_id = per.business_group_id;

Line 20111: from per_business_groups_perf bus

20107: --
20108: --
20109: cursor csr_grp_idsel is
20110: select bus.people_group_structure
20111: from per_business_groups_perf bus
20112: where bus.business_group_id = l_business_group_id;
20113: --
20114: cursor csr_scl_idsel is
20115: select plr.rule_mode id_flex_num

Line 20117: per_business_groups_perf pgr

20113: --
20114: cursor csr_scl_idsel is
20115: select plr.rule_mode id_flex_num
20116: from pay_legislation_rules plr,
20117: per_business_groups_perf pgr
20118: where plr.legislation_code = pgr.legislation_code
20119: and pgr.business_group_id = l_business_group_id
20120: and plr.rule_type = 'S'
20121: and exists

Line 21677: l_business_group_id per_business_groups.business_group_id%TYPE;

21673: l_comment_id per_all_assignments_f.comment_id%TYPE;
21674: l_group_name pay_people_groups.group_name%TYPE;
21675: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
21676: l_application_id per_applications.application_id%TYPE;
21677: l_business_group_id per_business_groups.business_group_id%TYPE;
21678: l_legislation_code per_business_groups.legislation_code%TYPE;
21679: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
21680: l_proc varchar2(72);
21681: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

Line 21678: l_legislation_code per_business_groups.legislation_code%TYPE;

21674: l_group_name pay_people_groups.group_name%TYPE;
21675: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
21676: l_application_id per_applications.application_id%TYPE;
21677: l_business_group_id per_business_groups.business_group_id%TYPE;
21678: l_legislation_code per_business_groups.legislation_code%TYPE;
21679: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
21680: l_proc varchar2(72);
21681: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
21682: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 22423: ,per_business_groups_perf bus

22419: ,person_id ,effective_end_date, application_id
22420: ,asg.assignment_status_type_id --7229710
22421: ,asg.effective_start_date -- Added for bug 9875744
22422: FROM per_all_assignments_f asg
22423: ,per_business_groups_perf bus
22424: WHERE asg.assignment_id = p_assignment_id
22425: AND bus.business_group_id = asg.business_group_id
22426: AND p_effective_date BETWEEN asg.effective_start_date
22427: AND asg.effective_end_date;