APPS.PQH_WKS_BUDGET dependencies on PER_VALID_GRADES

Line 20: cursor c1 is select 'x' from per_valid_grades

16: function valid_grade(p_position_id in number default null,
17: p_job_id in number default null,
18: p_grade_id in number) return varchar2 is
19: /*
20: cursor c1 is select 'x' from per_valid_grades
21: where (position_id = p_position_id or position_id is null)
22: and (job_id = p_job_id or job_id is null)
23: and grade_id = p_grade_id ;
24: */

Line 873: a.grade_id in (select b.grade_id from per_valid_grades b

869: and bgv.budget_version_id = p_budget_version_id;
870: cursor c1 is select grade_id from per_grades a
871: where business_group_id = p_business_group_id
872: and ((nvl(l_valid_grade_flag,'N') = 'Y' and l_budgeted_entity_cd = 'GRADE' and
873: a.grade_id in (select b.grade_id from per_valid_grades b
874: where b.date_from < l_budget_end_date
875: and (b.date_to > l_budget_start_date or b.date_to is null)))
876: or (nvl(l_valid_grade_flag,'N') = 'N' and date_from < l_budget_end_date
877: and (date_to > l_budget_start_date or date_to is null)))

Line 1527: from per_valid_grades

1523: p_grade_id number default null,
1524: p_valid_grade_flag varchar2 default null)
1525: Return varchar2 is
1526: Cursor C_position is select valid_grade_id
1527: from per_valid_grades
1528: where position_id = p_position_id
1529: and grade_id = p_grade_id
1530: and rownum < 2;
1531:

Line 1533: from per_valid_grades

1529: and grade_id = p_grade_id
1530: and rownum < 2;
1531:
1532: Cursor C_job is select valid_grade_id
1533: from per_valid_grades
1534: where job_id = p_job_id
1535: and grade_id = p_grade_id
1536: and rownum < 2;
1537:

Line 1538: l_valid_grade_id per_valid_grades.valid_grade_id%type;

1534: where job_id = p_job_id
1535: and grade_id = p_grade_id
1536: and rownum < 2;
1537:
1538: l_valid_grade_id per_valid_grades.valid_grade_id%type;
1539: Begin
1540: If nvl(p_grade_id,0) <> 0 then
1541: If nvl(p_valid_grade_flag,'N') = 'Y' then
1542: If p_position_id is not null then

Line 1570: l_job_id per_valid_grades.job_id%type :=p_job_id;

1566: p_grade_id number default null,
1567: p_start_bud_date date,
1568: p_end_bud_date date)
1569: Return varchar2 is
1570: l_job_id per_valid_grades.job_id%type :=p_job_id;
1571: Cursor C_job is select valid_grade_id
1572: from per_valid_grades
1573: where job_id = l_job_id
1574: and grade_id = p_grade_id

Line 1572: from per_valid_grades

1568: p_end_bud_date date)
1569: Return varchar2 is
1570: l_job_id per_valid_grades.job_id%type :=p_job_id;
1571: Cursor C_job is select valid_grade_id
1572: from per_valid_grades
1573: where job_id = l_job_id
1574: and grade_id = p_grade_id
1575: and date_from < p_end_bud_date
1576: and (date_to > p_start_bud_date or date_to is null)

Line 1580: from per_valid_grades

1576: and (date_to > p_start_bud_date or date_to is null)
1577: and rownum < 2;
1578:
1579: Cursor C_position is select valid_grade_id
1580: from per_valid_grades
1581: where position_id = p_position_id
1582: and grade_id = p_grade_id
1583: and date_from < p_end_bud_date
1584: and (date_to > p_start_bud_date or date_to is null)

Line 1588: from per_valid_grades

1584: and (date_to > p_start_bud_date or date_to is null)
1585: and rownum < 2;
1586:
1587: Cursor C2 is select valid_grade_id
1588: from per_valid_grades
1589: where grade_id = p_grade_id
1590: and date_from < p_end_bud_date
1591: and (date_to > p_start_bud_date or date_to is null)
1592: and rownum < 2;

Line 1593: l_valid_grade_id per_valid_grades.valid_grade_id%type;

1589: where grade_id = p_grade_id
1590: and date_from < p_end_bud_date
1591: and (date_to > p_start_bud_date or date_to is null)
1592: and rownum < 2;
1593: l_valid_grade_id per_valid_grades.valid_grade_id%type;
1594: Begin
1595: If p_position_id is not null then
1596: Open C_position;
1597: Fetch C_position into l_valid_grade_id;