APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PAY_INPUT_VALUES

Line 1079: FROM PAY_RATES pr, PER_PAY_BASES ppb, PAY_INPUT_VALUES piv

1075: AND business_group_id = p_business_group_id;
1076: --
1077: Cursor C_paybasis is
1078: SELECT pay_basis, piv.element_type_id
1079: FROM PAY_RATES pr, PER_PAY_BASES ppb, PAY_INPUT_VALUES piv
1080: WHERE pr.parent_spine_id = l_rate_or_payscale_id
1081: AND pr.rate_id = ppb.rate_id
1082: AND pr.business_group_id = p_business_group_id
1083: AND ppb.business_group_id = p_business_group_id

Line 1111: FROM PER_PAY_BASES ppb, PAY_INPUT_VALUES piv

1107:
1108: --
1109: Cursor C_rate_paybasis is
1110: SELECT ppb.pay_basis, piv.element_type_id
1111: FROM PER_PAY_BASES ppb, PAY_INPUT_VALUES piv
1112: WHERe ppb.rate_id = l_rate_id
1113: AND ppb.business_group_id = p_business_group_id
1114: AND ppb.input_value_id = piv.input_value_id;
1115: --

Line 2417: from pay_input_values piv,

2413:
2414:
2415: Cursor C_Pay_basis is
2416: Select element_type_id
2417: from pay_input_values piv,
2418: per_pay_bases ppb
2419: where ppb.pay_basis_id = le_pay_basis_id
2420: and piv.input_value_id = ppb.input_value_id;
2421:

Line 2853: from fnd_sessions fs, pay_input_values piv,

2849: v_gldummy number;
2850:
2851: Cursor C_Element_Type is
2852: Select element_type_id
2853: from fnd_sessions fs, pay_input_values piv,
2854: per_pay_bases ppb,
2855: per_all_assignments_f paf
2856: where fs.session_id = userenv('sessionid')
2857: and fs.effective_date between paf.effective_start_date and paf.effective_end_date