APPS.GHR_PAY_CALC dependencies on PER_POSITIONS

Line 1890: l_business_group_id per_positions.organization_id%TYPE;

1886: l_max_RA NUMBER;
1887:
1888:
1889: ------ GPPA Update 46 - GM Pay plan will change to GS pay plan for 890 NOAC
1890: l_business_group_id per_positions.organization_id%TYPE;
1891:
1892: CURSOR GET_GRADE_ID (v_pay_plan varchar2, v_grade_or_level varchar2) IS
1893: SELECT grd.grade_id grade_id
1894: FROM per_grades grd,

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

3156: RAISE;
3157: END sql_main_pay_calc;
3158:
3159: --
3160: FUNCTION get_pos_pay_basis (p_position_id IN per_positions.position_id%TYPE
3161: ,p_effective_date IN date)
3162: RETURN VARCHAR2 IS
3163: --
3164: -- Since Position Extra Info now has history use the history packages written to get

Line 4151: l_business_group_id per_positions.organization_id%TYPE;

4147: FROM pay_user_tables utb
4148: WHERE utb.user_table_name = p_user_table_name;
4149:
4150: ------ Bug#5741977 start
4151: l_business_group_id per_positions.organization_id%TYPE;
4152:
4153: CURSOR GET_GRADE_ID (v_pay_plan varchar2, v_grade_or_level varchar2) IS
4154: SELECT grd.grade_id grade_id
4155: FROM per_grades grd,