APPS.PAY_CONTINUOUS_CALC dependencies on PER_ASSIGNMENTS_F

Line 1302: from per_assignments_f

1298: is
1299: --
1300: cursor asgcur (p_person_id number) is
1301: select distinct assignment_id
1302: from per_assignments_f
1303: where person_id = p_person_id;
1304: --
1305: begin
1306: /* If the continuous calc is overriden then do nothing */

Line 4449: from per_assignments_f asg

4445: is
4446: --
4447: cursor get_asg (p_payroll_id in number) is
4448: select distinct asg.assignment_id
4449: from per_assignments_f asg
4450: where asg.payroll_id = p_payroll_id
4451: and p_effective_date < asg.effective_end_date;
4452: --
4453: begin

Line 5797: from per_assignments_f

5793: is
5794: --
5795: cursor asgcur (p_person_id number) is
5796: select distinct assignment_id
5797: from per_assignments_f
5798: where person_id = p_person_id;
5799: --
5800: l_process_event_id number;
5801: l_proc varchar2(240) := g_package||'.per_addresses_ari';

Line 5971: from per_assignments_f

5967: is
5968: --
5969: cursor asgcur (p_person_id number) is
5970: select distinct assignment_id
5971: from per_assignments_f
5972: where person_id = p_person_id;
5973: --
5974: begin
5975: /* If the continuous calc is overriden then do nothing */

Line 6514: from per_assignments_f

6510: l_proc varchar2(240) := g_package||'.PER_ALL_PEOPLE_F_ard';
6511: --
6512: cursor asgcur (p_person_id number) is
6513: select distinct assignment_id
6514: from per_assignments_f
6515: where person_id = p_person_id;
6516: --
6517: begin
6518: hr_utility.set_location(l_proc, 10);

Line 7058: from per_assignments_f

7054: is
7055: --
7056: cursor asgcur (p_person_id number) is
7057: select distinct assignment_id
7058: from per_assignments_f
7059: where person_id = p_person_id;
7060: --
7061: begin
7062: /* If the continuous calc is overriden then do nothing */

Line 9042: from per_assignments_f

9038: is
9039: --
9040: cursor asgcur (p_person_id number) is
9041: select distinct assignment_id
9042: from per_assignments_f
9043: where person_id = p_person_id;
9044: l_proc varchar2(240) := g_package||'.per_periods_of_service_aru';
9045:
9046: begin

Line 10434: from per_assignments_f

10430: is
10431: --
10432: cursor asgcur (p_person_id number) is
10433: select distinct assignment_id
10434: from per_assignments_f
10435: where person_id = p_person_id;
10436: l_proc varchar2(240) := g_package||'.per_performance_reviews_aru';
10437:
10438: begin

Line 11263: per_assignments_f paf

11259: cursor grade_chk is
11260: select '' chk
11261: from pay_grade_rules_f pgr,
11262: pay_assignment_actions paa,
11263: per_assignments_f paf
11264: where paa.assignment_action_id = p_assignment_action_id
11265: and pgr.grade_rule_id = p_surrogate_key
11266: and p_date between pgr.effective_start_date
11267: and pgr.effective_end_date