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.

[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 767: per_business_groups_perf pgr

763: --
764: cursor csr_scl_idsel is
765: select plr.rule_mode id_flex_num
766: from pay_legislation_rules plr,
767: per_business_groups_perf pgr
768: where plr.legislation_code = pgr.legislation_code
769: and pgr.business_group_id = p_business_group_id
770: and plr.rule_type = 'S'
771: and exists

Line 1598: l_legislation_code per_business_groups.legislation_code%TYPE;

1594: l_last_standard_process_date
1595: per_periods_of_service.last_standard_process_date%TYPE;
1596: l_actual_termination_date
1597: per_periods_of_service.actual_termination_date%TYPE;
1598: l_legislation_code per_business_groups.legislation_code%TYPE;
1599: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1600: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1601: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
1602: l_proc varchar2(72)

Line 1614: , per_business_groups_perf bus

1610: , asg.primary_flag
1611: , bus.business_group_id
1612: , bus.legislation_code
1613: from per_all_assignments_f asg
1614: , per_business_groups_perf bus
1615: where asg.assignment_id = p_assignment_id
1616: and l_actual_termination_date between asg.effective_start_date
1617: and asg.effective_end_date
1618: and bus.business_group_id+0 = asg.business_group_id;

Line 2508: l_legislation_code per_business_groups.legislation_code%TYPE;

2504: l_last_standard_process_date
2505: per_periods_of_service.last_standard_process_date%TYPE;
2506: l_actual_termination_date
2507: per_periods_of_service.actual_termination_date%TYPE;
2508: l_legislation_code per_business_groups.legislation_code%TYPE;
2509: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2510: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2511: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2512: l_proc varchar2(72)

Line 2524: , per_business_groups_perf bus

2520: , asg.primary_flag
2521: , bus.business_group_id
2522: , bus.legislation_code
2523: from per_all_assignments_f asg
2524: , per_business_groups_perf bus
2525: where asg.assignment_id = p_assignment_id
2526: and l_actual_termination_date between asg.effective_start_date
2527: and asg.effective_end_date
2528: and bus.business_group_id+0 = asg.business_group_id;

Line 3075: l_business_group_id per_business_groups.business_group_id%TYPE;

3071: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3072: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3073: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3074: --
3075: l_business_group_id per_business_groups.business_group_id%TYPE;
3076: l_legislation_code per_business_groups.legislation_code%TYPE;
3077: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3078: l_proc varchar2(72);
3079: l_session_id number;

Line 3076: l_legislation_code per_business_groups.legislation_code%TYPE;

3072: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3073: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3074: --
3075: l_business_group_id per_business_groups.business_group_id%TYPE;
3076: l_legislation_code per_business_groups.legislation_code%TYPE;
3077: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3078: l_proc varchar2(72);
3079: l_session_id number;
3080: l_cagr_grade_def_id number;

Line 3947: l_business_group_id per_business_groups.business_group_id%TYPE;

3943: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3944: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3945: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3946: --
3947: l_business_group_id per_business_groups.business_group_id%TYPE;
3948: l_legislation_code per_business_groups.legislation_code%TYPE;
3949: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3950: l_proc varchar2(72) := g_package||
3951: 'create_secondary_emp_asg';

Line 3948: l_legislation_code per_business_groups.legislation_code%TYPE;

3944: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3945: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3946: --
3947: l_business_group_id per_business_groups.business_group_id%TYPE;
3948: l_legislation_code per_business_groups.legislation_code%TYPE;
3949: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3950: l_proc varchar2(72) := g_package||
3951: 'create_secondary_emp_asg';
3952: l_session_id number;

Line 4396: l_business_group_id per_business_groups.business_group_id%TYPE;

4392: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4393: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4394: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4395: --
4396: l_business_group_id per_business_groups.business_group_id%TYPE;
4397: l_legislation_code per_business_groups.legislation_code%TYPE;
4398: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4399: l_proc varchar2(72) := g_package||
4400: 'create_secondary_emp_asg';

Line 4397: l_legislation_code per_business_groups.legislation_code%TYPE;

4393: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4394: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4395: --
4396: l_business_group_id per_business_groups.business_group_id%TYPE;
4397: l_legislation_code per_business_groups.legislation_code%TYPE;
4398: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4399: l_proc varchar2(72) := g_package||
4400: 'create_secondary_emp_asg';
4401: l_session_id number;

Line 4510: , per_business_groups_perf bus

4506: cursor csr_get_derived_details is
4507: select bus.business_group_id
4508: , bus.legislation_code
4509: from per_all_people_f per
4510: , per_business_groups_perf bus
4511: where per.person_id = p_person_id
4512: and l_effective_date between per.effective_start_date
4513: and per.effective_end_date
4514: and bus.business_group_id = per.business_group_id;

Line 4534: from per_business_groups_perf

4530: -- (grp keyflex) for the specified business group
4531: --
4532: cursor csr_grp_idsel is
4533: select people_group_structure
4534: from per_business_groups_perf
4535: where business_group_id = l_business_group_id;
4536: --
4537: --
4538: -- the cursor csr_scl_idsel selects the valid id_flex_num

Line 5915: l_business_group_id per_business_groups.business_group_id%TYPE;

5911: l_comment_id per_all_assignments_f.comment_id%TYPE;
5912: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5913: l_group_name pay_people_groups.group_name%TYPE;
5914: l_session_id NUMBER;
5915: l_business_group_id per_business_groups.business_group_id%TYPE;
5916: l_legislation_code per_business_groups.legislation_code%TYPE;
5917: l_pop_date_start DATE;
5918: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
5919: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 5916: l_legislation_code per_business_groups.legislation_code%TYPE;

5912: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5913: l_group_name pay_people_groups.group_name%TYPE;
5914: l_session_id NUMBER;
5915: l_business_group_id per_business_groups.business_group_id%TYPE;
5916: l_legislation_code per_business_groups.legislation_code%TYPE;
5917: l_pop_date_start DATE;
5918: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
5919: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5920: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 5937: , per_business_groups_perf bus

5933: cursor csr_get_derived_details is
5934: select bus.business_group_id
5935: , bus.legislation_code
5936: from per_all_people_f per
5937: , per_business_groups_perf bus
5938: where per.person_id = p_person_id
5939: and l_effective_date between per.effective_start_date
5940: and per.effective_end_date
5941: and bus.business_group_id = per.business_group_id;

Line 5957: from per_business_groups_perf

5953: -- (grp keyflex) for the specified business group
5954: --
5955: cursor csr_grp_idsel is
5956: select people_group_structure
5957: from per_business_groups_perf
5958: where business_group_id = l_business_group_id;
5959: --
5960: --
5961: -- the cursor csr_scl_idsel selects the valid id_flex_num

Line 7173: l_legislation_code per_business_groups.legislation_code%TYPE;

7169: --
7170: -- Assigned the value p_assignment_number for fix of #2823013
7171: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
7172: l_effective_date date;
7173: l_legislation_code per_business_groups.legislation_code%TYPE;
7174: l_proc varchar2(72);
7175: --
7176: -- Declare dummy variables
7177: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 7185: per_business_groups_perf pbg

7181: --
7182: cursor csr_legislation is
7183: select null
7184: from per_all_assignments_f paf,
7185: per_business_groups_perf pbg
7186: where paf.person_id = p_person_id
7187: and l_effective_date between paf.effective_start_date
7188: and paf.effective_end_date
7189: and pbg.business_group_id = paf.business_group_id

Line 7482: l_legislation_code per_business_groups.legislation_code%TYPE;

7478: --
7479: -- Assigned the value p_assignment_number for fix of #2823013
7480: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
7481: l_effective_date date;
7482: l_legislation_code per_business_groups.legislation_code%TYPE;
7483: l_proc varchar2(72);
7484: --
7485: -- Declare dummy variables
7486: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 7494: per_business_groups_perf pbg

7490: --
7491: cursor csr_legislation is
7492: select null
7493: from per_all_assignments_f paf,
7494: per_business_groups_perf pbg
7495: where paf.person_id = p_person_id
7496: and l_effective_date between paf.effective_start_date
7497: and paf.effective_end_date
7498: and pbg.business_group_id = paf.business_group_id

Line 7807: l_business_group_id per_business_groups.business_group_id%TYPE;

7803: -- WWBUG 2539685
7804: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
7805: l_effective_date date;
7806: --
7807: l_business_group_id per_business_groups.business_group_id%TYPE;
7808: l_legislation_code per_business_groups.legislation_code%TYPE;
7809: l_proc varchar2(72);
7810: --
7811: -- Declare cursors

Line 7808: l_legislation_code per_business_groups.legislation_code%TYPE;

7804: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
7805: l_effective_date date;
7806: --
7807: l_business_group_id per_business_groups.business_group_id%TYPE;
7808: l_legislation_code per_business_groups.legislation_code%TYPE;
7809: l_proc varchar2(72);
7810: --
7811: -- Declare cursors
7812: --

Line 7816: per_business_groups_perf pbg

7812: --
7813: cursor csr_legislation is
7814: select null
7815: from per_all_assignments_f paf,
7816: per_business_groups_perf pbg
7817: where paf.person_id = p_person_id
7818: and l_effective_date between paf.effective_start_date
7819: and paf.effective_end_date
7820: and pbg.business_group_id = paf.business_group_id

Line 8140: l_business_group_id per_business_groups.business_group_id%TYPE;

8136: -- Assigned the value p_assignment_number for fix of #2823013
8137: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8138: l_effective_date date;
8139: --
8140: l_business_group_id per_business_groups.business_group_id%TYPE;
8141: l_legislation_code per_business_groups.legislation_code%TYPE;
8142: l_proc varchar2(72);
8143: --
8144: -- Declare cursors

Line 8141: l_legislation_code per_business_groups.legislation_code%TYPE;

8137: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8138: l_effective_date date;
8139: --
8140: l_business_group_id per_business_groups.business_group_id%TYPE;
8141: l_legislation_code per_business_groups.legislation_code%TYPE;
8142: l_proc varchar2(72);
8143: --
8144: -- Declare cursors
8145: --

Line 8149: per_business_groups_perf pbg

8145: --
8146: cursor csr_legislation is
8147: select null
8148: from per_all_assignments_f paf,
8149: per_business_groups_perf pbg
8150: where paf.person_id = p_person_id
8151: and l_effective_date between paf.effective_start_date
8152: and paf.effective_end_date
8153: and pbg.business_group_id = paf.business_group_id

Line 9636: l_business_group_id per_business_groups.business_group_id%TYPE;

9632: --
9633: -- Internal working variables
9634: --
9635: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
9636: l_business_group_id per_business_groups.business_group_id%TYPE;
9637: l_payroll_id_updated boolean;
9638: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9639: l_org_now_no_manager_warning boolean;
9640: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 9992: l_business_group_id per_business_groups.business_group_id%TYPE;

9988: --
9989: -- Internal working variables
9990: --
9991: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
9992: l_business_group_id per_business_groups.business_group_id%TYPE;
9993: l_payroll_id_updated boolean;
9994: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9995: l_org_now_no_manager_warning boolean;
9996: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 10106: per_business_groups_perf pgr

10102: --
10103: cursor csr_scl_idsel is
10104: select plr.rule_mode id_flex_num
10105: from pay_legislation_rules plr,
10106: per_business_groups_perf pgr
10107: where plr.legislation_code = pgr.legislation_code
10108: and pgr.business_group_id = l_business_group_id
10109: and plr.rule_type = 'S'
10110: and exists

Line 11296: l_business_group_id per_business_groups.business_group_id%TYPE;

11292: l_proc VARCHAR2(72) := g_package||'update_cwk_asg';
11293: l_effective_date DATE;
11294: l_projected_assignment_end DATE;
11295: l_organization_id per_all_assignments_f.organization_id%TYPE;
11296: l_business_group_id per_business_groups.business_group_id%TYPE;
11297: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11298: l_location_id per_all_assignments_f.location_id%TYPE;
11299: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11300: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;

Line 11345: per_business_groups_perf pgr

11341: --
11342: cursor csr_scl_idsel is
11343: select plr.rule_mode id_flex_num
11344: from pay_legislation_rules plr,
11345: per_business_groups_perf pgr
11346: where plr.legislation_code = pgr.legislation_code
11347: and pgr.business_group_id = l_business_group_id
11348: and plr.rule_type = 'CWK_S'
11349: and exists

Line 12253: l_legislation_code per_business_groups.legislation_code%TYPE;

12249: l_api_updating boolean;
12250: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12251: l_comment_id per_all_assignments_f.comment_id%TYPE;
12252: l_entries_changed varchar2(1);
12253: l_legislation_code per_business_groups.legislation_code%TYPE;
12254: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
12255: l_proc varchar2(72) :=
12256: g_package || 'update_cwk_asg_criteria';
12257: l_validation_end_date date;

Line 12272: from per_business_groups_perf bus

12268: --
12269:
12270: cursor csr_get_legislation_code is
12271: select bus.legislation_code
12272: from per_business_groups_perf bus
12273: where bus.business_group_id = l_business_group_id;
12274: --
12275: cursor csr_get_salary is
12276: select element_entry_id

Line 12285: from per_business_groups_perf bus

12281: effective_start_date and effective_end_date;
12282: --
12283: cursor csr_grp_idsel is
12284: select bus.people_group_structure
12285: from per_business_groups_perf bus
12286: where bus.business_group_id = l_business_group_id;
12287: --
12288: cursor get_sec_date_range is
12289: select asg.effective_start_date

Line 13142: l_legislation_code per_business_groups.legislation_code%TYPE;

13138: l_proc varchar2(72);
13139: l_effective_date date;
13140: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13141: l_concatenated_segments varchar2(2000);
13142: l_legislation_code per_business_groups.legislation_code%TYPE;
13143: l_cagr_concatenated_segments varchar2(300);
13144: l_cagr_grade_def_id number;
13145: --
13146: --

Line 13327: l_legislation_code per_business_groups.legislation_code%TYPE;

13323: l_proc varchar2(72);
13324: l_effective_date date;
13325: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13326: l_concatenated_segments varchar2(2000);
13327: l_legislation_code per_business_groups.legislation_code%TYPE;
13328: --
13329: cursor check_legislation
13330: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
13331: c_effective_date date

Line 13336: per_business_groups_perf bgp

13332: )
13333: is
13334: select bgp.legislation_code
13335: from per_all_assignments_f asg,
13336: per_business_groups_perf bgp
13337: where asg.business_group_id = bgp.business_group_id
13338: and asg.assignment_id = c_assignment_id
13339: and c_effective_date
13340: between effective_start_date and effective_end_date;

Line 13564: l_legislation_code per_business_groups.legislation_code%TYPE;

13560: l_proc varchar2(72);
13561: l_effective_date date;
13562: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13563: l_concatenated_segments varchar2(2000);
13564: l_legislation_code per_business_groups.legislation_code%TYPE;
13565: --
13566: cursor check_legislation
13567: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
13568: c_effective_date date

Line 13573: per_business_groups_perf bgp

13569: )
13570: is
13571: select bgp.legislation_code
13572: from per_all_assignments_f asg,
13573: per_business_groups_perf bgp
13574: where asg.business_group_id = bgp.business_group_id
13575: and asg.assignment_id = c_assignment_id
13576: and c_effective_date
13577: between effective_start_date and effective_end_date;

Line 13799: l_legislation_code per_business_groups.legislation_code%TYPE;

13795: -- Declare cursors and local variables
13796: --
13797: l_proc varchar2(72);
13798: l_effective_date date;
13799: l_legislation_code per_business_groups.legislation_code%TYPE;
13800: l_cagr_grade_def_id number;
13801: l_cagr_concatenated_segments number;
13802:
13803: --

Line 14011: l_legislation_code per_business_groups.legislation_code%TYPE;

14007: -- Declare cursors and local variables
14008: --
14009: l_proc varchar2(72);
14010: l_effective_date date;
14011: l_legislation_code per_business_groups.legislation_code%TYPE;
14012:
14013: --
14014: cursor check_legislation
14015: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 14021: per_business_groups_perf bgp

14017: )
14018: is
14019: select bgp.legislation_code
14020: from per_all_assignments_f asg,
14021: per_business_groups_perf bgp
14022: where asg.business_group_id = bgp.business_group_id
14023: and asg.assignment_id = c_assignment_id
14024: and c_effective_date
14025: between effective_start_date and effective_end_date;

Line 14276: l_legislation_code per_business_groups.legislation_code%TYPE;

14272: -- Declare cursors and local variables
14273: --
14274: l_proc varchar2(72);
14275: l_effective_date date;
14276: l_legislation_code per_business_groups.legislation_code%TYPE;
14277: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
14278:
14279: --
14280: cursor check_legislation

Line 14287: per_business_groups_perf bgp

14283: )
14284: is
14285: select bgp.legislation_code
14286: from per_all_assignments_f asg,
14287: per_business_groups_perf bgp
14288: where asg.business_group_id = bgp.business_group_id
14289: and asg.assignment_id = c_assignment_id
14290: and c_effective_date
14291: between effective_start_date and effective_end_date;

Line 14545: l_legislation_code per_business_groups.legislation_code%TYPE;

14541: -- Declare cursors and local variables
14542: --
14543: l_proc varchar2(72);
14544: l_effective_date date;
14545: l_legislation_code per_business_groups.legislation_code%TYPE;
14546:
14547: --
14548: cursor check_legislation
14549: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 14555: per_business_groups_perf bgp

14551: )
14552: is
14553: select bgp.legislation_code
14554: from per_all_assignments_f asg,
14555: per_business_groups_perf bgp
14556: where asg.business_group_id = bgp.business_group_id
14557: and asg.assignment_id = c_assignment_id
14558: and c_effective_date
14559: between effective_start_date and effective_end_date;

Line 15027: l_legislation_code per_business_groups.legislation_code%TYPE;

15023: l_api_updating boolean;
15024: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15025: l_comment_id per_all_assignments_f.comment_id%TYPE;
15026: l_entries_changed varchar2(1);
15027: l_legislation_code per_business_groups.legislation_code%TYPE;
15028: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15029: l_proc varchar2(72) :=
15030: g_package || 'update_emp_asg_criteria';
15031:

Line 15241: l_legislation_code per_business_groups.legislation_code%TYPE;

15237: l_api_updating boolean;
15238: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15239: l_comment_id per_all_assignments_f.comment_id%TYPE;
15240: l_entries_changed varchar2(1);
15241: l_legislation_code per_business_groups.legislation_code%TYPE;
15242: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15243: l_proc varchar2(72) :=
15244: g_package || 'update_emp_asg_criteria';
15245: l_validation_end_date date;

Line 15381: from per_business_groups_perf bus

15377: where people_group_id = l_people_group_id;
15378: --
15379: cursor csr_get_legislation_code is
15380: select bus.legislation_code
15381: from per_business_groups_perf bus
15382: where bus.business_group_id = l_business_group_id;
15383: --
15384: cursor csr_get_salary is
15385: select element_entry_id

Line 15405: from per_business_groups_perf bus

15401: -- end of fix for bug 4464072
15402: --
15403: cursor csr_grp_idsel is
15404: select bus.people_group_structure
15405: from per_business_groups_perf bus
15406: where bus.business_group_id = l_business_group_id;
15407: --
15408: cursor get_sec_date_range is
15409: select asg.effective_start_date

Line 16848: from per_business_groups_perf bus

16844: --
16845: --
16846: cursor csr_grp_idsel is
16847: select bus.people_group_structure
16848: from per_business_groups_perf bus
16849: where bus.business_group_id = l_business_group_id;
16850: --
16851: cursor csr_scl_idsel is
16852: select plr.rule_mode id_flex_num

Line 16854: per_business_groups_perf pgr

16850: --
16851: cursor csr_scl_idsel is
16852: select plr.rule_mode id_flex_num
16853: from pay_legislation_rules plr,
16854: per_business_groups_perf pgr
16855: where plr.legislation_code = pgr.legislation_code
16856: and pgr.business_group_id = l_business_group_id
16857: and plr.rule_type = 'S'
16858: and exists

Line 17567: -- per_business_groups_perf

17563: -- Added this additional check
17564: or p_scl_concat_segments <> hr_api.g_varchar2
17565: then
17566: -- gets flex num id from pay_legislation_rules and
17567: -- per_business_groups_perf
17568: --
17569: open csr_scl_idsel;
17570: fetch csr_scl_idsel into l_flex_num;
17571: --

Line 18385: l_business_group_id per_business_groups.business_group_id%TYPE;

18381: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
18382: --
18383: -- Internal working variables
18384: --
18385: l_business_group_id per_business_groups.business_group_id%TYPE;
18386: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
18387: l_group_name pay_people_groups.group_name%TYPE;
18388: l_proc varchar2(72);
18389: l_api_updating boolean;

Line 19099: l_business_group_id per_business_groups.business_group_id%TYPE;

19095: l_group_name pay_people_groups.group_name%TYPE;
19096: l_old_group_name pay_people_groups.group_name%TYPE;
19097: --
19098: l_application_id per_applications.application_id%TYPE;
19099: l_business_group_id per_business_groups.business_group_id%TYPE;
19100: l_legislation_code per_business_groups.legislation_code%TYPE;
19101: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
19102: l_proc varchar2(72) := g_package||'create_secondary_apl_asg';
19103: l_effective_date date;

Line 19100: l_legislation_code per_business_groups.legislation_code%TYPE;

19096: l_old_group_name pay_people_groups.group_name%TYPE;
19097: --
19098: l_application_id per_applications.application_id%TYPE;
19099: l_business_group_id per_business_groups.business_group_id%TYPE;
19100: l_legislation_code per_business_groups.legislation_code%TYPE;
19101: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
19102: l_proc varchar2(72) := g_package||'create_secondary_apl_asg';
19103: l_effective_date date;
19104: l_date_probation_end date;

Line 19223: , per_business_groups_perf bus

19219: select bus.business_group_id
19220: , bus.legislation_code
19221: , per.applicant_number, per.object_version_number --3652025
19222: from per_all_people_f per
19223: , per_business_groups_perf bus
19224: where per.person_id = p_person_id
19225: and l_effective_date between per.effective_start_date
19226: and per.effective_end_date
19227: and bus.business_group_id = per.business_group_id;

Line 19248: from per_business_groups_perf bus

19244: --
19245: --
19246: cursor csr_grp_idsel is
19247: select bus.people_group_structure
19248: from per_business_groups_perf bus
19249: where bus.business_group_id = l_business_group_id;
19250: --
19251: cursor csr_scl_idsel is
19252: select plr.rule_mode id_flex_num

Line 19254: per_business_groups_perf pgr

19250: --
19251: cursor csr_scl_idsel is
19252: select plr.rule_mode id_flex_num
19253: from pay_legislation_rules plr,
19254: per_business_groups_perf pgr
19255: where plr.legislation_code = pgr.legislation_code
19256: and pgr.business_group_id = l_business_group_id
19257: and plr.rule_type = 'S'
19258: and exists

Line 20814: l_business_group_id per_business_groups.business_group_id%TYPE;

20810: l_comment_id per_all_assignments_f.comment_id%TYPE;
20811: l_group_name pay_people_groups.group_name%TYPE;
20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
20813: l_application_id per_applications.application_id%TYPE;
20814: l_business_group_id per_business_groups.business_group_id%TYPE;
20815: l_legislation_code per_business_groups.legislation_code%TYPE;
20816: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
20817: l_proc varchar2(72);
20818: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

Line 20815: l_legislation_code per_business_groups.legislation_code%TYPE;

20811: l_group_name pay_people_groups.group_name%TYPE;
20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
20813: l_application_id per_applications.application_id%TYPE;
20814: l_business_group_id per_business_groups.business_group_id%TYPE;
20815: l_legislation_code per_business_groups.legislation_code%TYPE;
20816: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
20817: l_proc varchar2(72);
20818: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
20819: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 21530: ,per_business_groups_perf bus

21526: ,bus.legislation_code
21527: ,person_id ,effective_end_date, application_id
21528: ,asg.assignment_status_type_id --7229710
21529: FROM per_all_assignments_f asg
21530: ,per_business_groups_perf bus
21531: WHERE asg.assignment_id = p_assignment_id
21532: AND bus.business_group_id = asg.business_group_id
21533: AND p_effective_date BETWEEN asg.effective_start_date
21534: AND asg.effective_end_date;