DBA Data[Home] [Help]

APPS.GHR_PC_BASIC_PAY dependencies on PER_POSITIONS

Line 2727: l_business_group_id per_positions.organization_id%TYPE;

2723: l_new_rangeval_min NUMBER;
2724: l_new_rangeval_max NUMBER;
2725:
2726: -- perf cert
2727: l_business_group_id per_positions.organization_id%TYPE;
2728: l_agency_subele_code per_position_definitions.segment4%TYPE;
2729: l_org_id per_positions.organization_id%TYPE;
2730: l_old_non_perfagn_max NUMBER;
2731: l_new_non_perfagn_max NUMBER;

Line 2729: l_org_id per_positions.organization_id%TYPE;

2725:
2726: -- perf cert
2727: l_business_group_id per_positions.organization_id%TYPE;
2728: l_agency_subele_code per_position_definitions.segment4%TYPE;
2729: l_org_id per_positions.organization_id%TYPE;
2730: l_old_non_perfagn_max NUMBER;
2731: l_new_non_perfagn_max NUMBER;
2732:
2733:

Line 2741: CURSOR cur_get_pos_org(p_pos_id per_positions.position_id%TYPE,

2737: stp_4 NUMBER;
2738: stp_5 NUMBER;
2739: l_basic_pay NUMBER;
2740:
2741: CURSOR cur_get_pos_org(p_pos_id per_positions.position_id%TYPE,
2742: p_eff_Date ghr_pa_requests.effective_date%TYPE)
2743: IS
2744: SELECT ORGANIZATION_ID FROM HR_POSITIONS_F
2745: WHERE position_id=p_pos_id