[Home] [Help]
226: null, 1,
227: 0, 1,
228: ppb.pay_annualization_factor) * ppp.proposed_salary_n
229: ,petf.input_currency_code
230: FROM per_pay_bases ppb, per_assignments_f paf
231: ,per_pay_proposals ppp, pay_input_values_f ivf, pay_element_types_f petf
232: WHERE paf.person_id = p_person_id
233: AND paf.primary_flag = 'Y'
234: AND paf.assignment_type = 'E'
438:
439: select gr.currency_code, gr.minimum, gr.mid_value, gr.maximum, petf.input_currency_code,
440: pb.grade_annualization_factor, ppp.proposed_salary_n, pb.pay_annualization_factor
441: from pay_input_values_f ivf, pay_element_types_f petf, pay_grade_rules_f gr,
442: per_pay_bases pb, per_assignments_f paf, per_pay_proposals ppp
443: where paf.assignment_id = p_assignment_id
444: AND paf.pay_basis_id = pb.pay_basis_id
445: and paf.assignment_id = ppp.assignment_id(+)
446: and pb.input_value_id = ivf.input_value_id
693: FUNCTION getAsgGradeRule(p_pay_proposal_id IN NUMBER) RETURN ROWID IS
694: l_rowid ROWID:=NULL;
695: CURSOR c_graderule IS
696: SELECT gr.rowid
697: FROM per_pay_proposals ppp, per_assignments_f paf
698: ,per_pay_bases pb, pay_grade_rules_f gr
699: WHERE ppp.pay_proposal_id = p_pay_proposal_id
700: AND ppp.assignment_id = paf.assignment_id
701: AND ppp.change_date between paf.effective_start_date and paf.effective_end_date
783: ||
784: ||===========================================================================
785: */
786:
787: FUNCTION get_display_job_name(p_job_id IN per_assignments_f.job_id%TYPE)
788: RETURN VARCHAR2
789: IS
790:
791: l_name varchar2(100) ;
1058: CURSOR lc_get_lad (p_person_id IN per_people_f.person_id%TYPE)
1059: IS
1060: SELECT MAX(pa.date_received)
1061: FROM per_applications pa,
1062: per_assignments_f ass
1063: WHERE ass.application_id = pa.application_id
1064: AND ass.assignment_type = 'A'
1065: AND ass.person_id = p_person_id;
1066:
1204: ||
1205: ||===========================================================================
1206: */
1207:
1208: FUNCTION get_currency(p_assignment_id IN per_assignments_f.assignment_id%TYPE
1209: ,p_change_date IN DATE)
1210: RETURN pay_element_types_f.input_currency_code%TYPE
1211: IS
1212:
1211: IS
1212:
1213: lv_result pay_element_types_f.input_currency_code%TYPE;
1214:
1215: CURSOR lc_get_currency(p_assign_id IN per_assignments_f.assignment_id%TYPE
1216: ,p_change_date IN DATE)
1217: IS
1218: SELECT pet.input_currency_code
1219: FROM pay_element_types_f pet
1218: SELECT pet.input_currency_code
1219: FROM pay_element_types_f pet
1220: , pay_input_values_f piv
1221: , per_pay_bases ppb
1222: , per_assignments_f paf
1223: WHERE paf.assignment_id = p_assign_id
1224: AND p_change_date BETWEEN paf.effective_start_date
1225: AND paf.effective_end_date
1226: AND ppb.pay_basis_id = paf.pay_basis_id
1263: ||===========================================================================
1264: */
1265:
1266: FUNCTION get_annual_salary(
1267: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
1268: p_change_date IN DATE
1269: )
1270: RETURN VARCHAR2
1271: IS
1274: ln_annual_factor NUMBER;
1275: ln_proposed_salary NUMBER;
1276: lv_format_string VARCHAR2(30);
1277:
1278: CURSOR lc_get_salary(p_assign_id IN per_assignments_f.assignment_id%TYPE
1279: ,p_change_date IN DATE)
1280: IS
1281: SELECT ppb.pay_annualization_factor
1282: , ppp.proposed_salary_n
1280: IS
1281: SELECT ppb.pay_annualization_factor
1282: , ppp.proposed_salary_n
1283: FROM per_pay_bases ppb
1284: , per_assignments_f paf
1285: , per_pay_proposals ppp
1286: WHERE paf.assignment_id = p_assign_id
1287: AND p_change_date BETWEEN paf.effective_start_date
1288: AND NVL(paf.effective_end_date, p_change_date)
1339: ||
1340: ||===========================================================================
1341: */
1342:
1343: FUNCTION get_job(p_job_id IN per_assignments_f.job_id%TYPE)
1344: RETURN VARCHAR2
1345: IS
1346:
1347: -- Job Keyflex Id is stored in org_information6 in
1352: FROM hr_organization_information
1353: WHERE organization_id = p_business_group_id
1354: AND org_information_context = 'Business Group Information';
1355:
1356: CURSOR lc_get_job_details(p_job_id IN per_assignments_f.job_id%TYPE)
1357: IS
1358: SELECT pj.name,
1359: pjd.segment1,
1360: pjd.segment2,
1489: ||
1490: ||===========================================================================
1491: */
1492:
1493: FUNCTION get_grade(p_grade_id IN per_assignments_f.grade_id%TYPE)
1494: RETURN VARCHAR2
1495: IS
1496:
1497: -- Grade Keyflex Id is stored in org_information4 in
1502: FROM hr_organization_information
1503: WHERE organization_id = p_business_group_id
1504: AND org_information_context = 'Business Group Information';
1505:
1506: CURSOR lc_get_grade_details(p_grade_id IN per_assignments_f.grade_id%TYPE)
1507: IS
1508: SELECT pg.name,
1509: pgd.segment1,
1510: pgd.segment2,
1640: ||
1641: ||===========================================================================
1642: */
1643:
1644: FUNCTION get_position(p_position_id IN per_assignments_f.position_id%TYPE
1645: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
1646: RETURN VARCHAR2
1647: IS
1648:
1655: WHERE organization_id = p_business_group_id
1656: AND org_information_context = 'Business Group Information';
1657:
1658: CURSOR lc_get_position_details(
1659: p_position_id IN per_assignments_f.position_id%TYPE
1660: )
1661: IS
1662: SELECT pp.name,
1663: ppd.segment1,