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 869: a.grade_id in (select b.grade_id from per_valid_grades b

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

Line 1522: from per_valid_grades

1518: p_grade_id number default null,
1519: p_valid_grade_flag varchar2 default null)
1520: Return varchar2 is
1521: Cursor C_position is select valid_grade_id
1522: from per_valid_grades
1523: where position_id = p_position_id
1524: and grade_id = p_grade_id
1525: and rownum < 2;
1526:

Line 1528: from per_valid_grades

1524: and grade_id = p_grade_id
1525: and rownum < 2;
1526:
1527: Cursor C_job is select valid_grade_id
1528: from per_valid_grades
1529: where job_id = p_job_id
1530: and grade_id = p_grade_id
1531: and rownum < 2;
1532:

Line 1533: l_valid_grade_id per_valid_grades.valid_grade_id%type;

1529: where job_id = p_job_id
1530: and grade_id = p_grade_id
1531: and rownum < 2;
1532:
1533: l_valid_grade_id per_valid_grades.valid_grade_id%type;
1534: Begin
1535: If nvl(p_grade_id,0) <> 0 then
1536: If nvl(p_valid_grade_flag,'N') = 'Y' then
1537: If p_position_id is not null then

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

1561: p_grade_id number default null,
1562: p_start_bud_date date,
1563: p_end_bud_date date)
1564: Return varchar2 is
1565: l_job_id per_valid_grades.job_id%type :=p_job_id;
1566: Cursor C_job is select valid_grade_id
1567: from per_valid_grades
1568: where job_id = l_job_id
1569: and grade_id = p_grade_id

Line 1567: from per_valid_grades

1563: p_end_bud_date date)
1564: Return varchar2 is
1565: l_job_id per_valid_grades.job_id%type :=p_job_id;
1566: Cursor C_job is select valid_grade_id
1567: from per_valid_grades
1568: where job_id = l_job_id
1569: and grade_id = p_grade_id
1570: and date_from < p_end_bud_date
1571: and (date_to > p_start_bud_date or date_to is null)

Line 1575: from per_valid_grades

1571: and (date_to > p_start_bud_date or date_to is null)
1572: and rownum < 2;
1573:
1574: Cursor C_position is select valid_grade_id
1575: from per_valid_grades
1576: where position_id = p_position_id
1577: and grade_id = p_grade_id
1578: and date_from < p_end_bud_date
1579: and (date_to > p_start_bud_date or date_to is null)

Line 1583: from per_valid_grades

1579: and (date_to > p_start_bud_date or date_to is null)
1580: and rownum < 2;
1581:
1582: Cursor C2 is select valid_grade_id
1583: from per_valid_grades
1584: where grade_id = p_grade_id
1585: and date_from < p_end_bud_date
1586: and (date_to > p_start_bud_date or date_to is null)
1587: and rownum < 2;

Line 1588: l_valid_grade_id per_valid_grades.valid_grade_id%type;

1584: where grade_id = p_grade_id
1585: and date_from < p_end_bud_date
1586: and (date_to > p_start_bud_date or date_to is null)
1587: and rownum < 2;
1588: l_valid_grade_id per_valid_grades.valid_grade_id%type;
1589: Begin
1590: If p_position_id is not null then
1591: Open C_position;
1592: Fetch C_position into l_valid_grade_id;