APPS.PAY_CONTINUOUS_CALC dependencies on PER_ASSIGNMENTS_F

Line 1334: from per_assignments_f

1330: is
1331: --
1332: cursor asgcur (p_person_id number) is
1333: select distinct assignment_id
1334: from per_assignments_f
1335: where person_id = p_person_id;
1336: --
1337: begin
1338: /* If the continuous calc is overriden then do nothing */

Line 4481: from per_assignments_f asg

4477: is
4478: --
4479: cursor get_asg (p_payroll_id in number) is
4480: select distinct asg.assignment_id
4481: from per_assignments_f asg
4482: where asg.payroll_id = p_payroll_id
4483: and p_effective_date < asg.effective_end_date;
4484: --
4485: begin

Line 5829: from per_assignments_f

5825: is
5826: --
5827: cursor asgcur (p_person_id number) is
5828: select distinct assignment_id
5829: from per_assignments_f
5830: where person_id = p_person_id;
5831: --
5832: l_process_event_id number;
5833: l_proc varchar2(240) := g_package||'.per_addresses_ari';

Line 6003: from per_assignments_f

5999: is
6000: --
6001: cursor asgcur (p_person_id number) is
6002: select distinct assignment_id
6003: from per_assignments_f
6004: where person_id = p_person_id;
6005: --
6006: begin
6007: /* If the continuous calc is overriden then do nothing */

Line 6546: from per_assignments_f

6542: l_proc varchar2(240) := g_package||'.PER_ALL_PEOPLE_F_ard';
6543: --
6544: cursor asgcur (p_person_id number) is
6545: select distinct assignment_id
6546: from per_assignments_f
6547: where person_id = p_person_id;
6548: --
6549: begin
6550: hr_utility.set_location(l_proc, 10);

Line 7090: from per_assignments_f

7086: is
7087: --
7088: cursor asgcur (p_person_id number) is
7089: select distinct assignment_id
7090: from per_assignments_f
7091: where person_id = p_person_id;
7092: --
7093: begin
7094: /* If the continuous calc is overriden then do nothing */

Line 9074: from per_assignments_f

9070: is
9071: --
9072: cursor asgcur (p_person_id number) is
9073: select distinct assignment_id
9074: from per_assignments_f
9075: where person_id = p_person_id;
9076: l_proc varchar2(240) := g_package||'.per_periods_of_service_aru';
9077:
9078: begin

Line 10466: from per_assignments_f

10462: is
10463: --
10464: cursor asgcur (p_person_id number) is
10465: select distinct assignment_id
10466: from per_assignments_f
10467: where person_id = p_person_id;
10468: l_proc varchar2(240) := g_package||'.per_performance_reviews_aru';
10469:
10470: begin

Line 11295: per_assignments_f paf

11291: cursor grade_chk is
11292: select '' chk
11293: from pay_grade_rules_f pgr,
11294: pay_assignment_actions paa,
11295: per_assignments_f paf
11296: where paa.assignment_action_id = p_assignment_action_id
11297: and pgr.grade_rule_id = p_surrogate_key
11298: and p_date between pgr.effective_start_date
11299: and pgr.effective_end_date

Line 12600: from per_assignments_f

12596: is
12597:
12598: cursor asgcur (p_person_id number) is
12599: select distinct assignment_id
12600: from per_assignments_f
12601: where person_id = p_person_id;
12602: l_proc varchar2(100) := 'PER_CONTACT_RELATIONSHIPS_ARU';
12603: --
12604: begin