APPS.GHR_PAY_CALC dependencies on PER_POSITIONS

Line 1826: l_business_group_id per_positions.organization_id%TYPE;

1822: l_max_RA NUMBER;
1823:
1824:
1825: ------ GPPA Update 46 - GM Pay plan will change to GS pay plan for 890 NOAC
1826: l_business_group_id per_positions.organization_id%TYPE;
1827:
1828: CURSOR GET_GRADE_ID (v_pay_plan varchar2, v_grade_or_level varchar2) IS
1829: SELECT grd.grade_id grade_id
1830: FROM per_grades grd,

Line 2946: FUNCTION get_pos_pay_basis (p_position_id IN per_positions.position_id%TYPE

2942: RAISE;
2943: END sql_main_pay_calc;
2944:
2945: --
2946: FUNCTION get_pos_pay_basis (p_position_id IN per_positions.position_id%TYPE
2947: ,p_effective_date IN date)
2948: RETURN VARCHAR2 IS
2949: --
2950: -- Since Position Extra Info now has history use the history packages written to get

Line 3933: l_business_group_id per_positions.organization_id%TYPE;

3929: FROM pay_user_tables utb
3930: WHERE utb.user_table_name = p_user_table_name;
3931:
3932: ------ Bug#5741977 start
3933: l_business_group_id per_positions.organization_id%TYPE;
3934:
3935: CURSOR GET_GRADE_ID (v_pay_plan varchar2, v_grade_or_level varchar2) IS
3936: SELECT grd.grade_id grade_id
3937: FROM per_grades grd,