APPS.PSB_WS_POS3 dependencies on PSB_PARAMETER_FORMULAS

Line 537: PSB_PARAMETER_FORMULAS pf

533: where pp.data_extract_id = l_data_extract_id
534: and exists
535: (select 1
536: from PSB_POSITION_ASSIGNMENTS pa,
537: PSB_PARAMETER_FORMULAS pf
538: where pa.position_id = pp.position_id
539: and pa.data_extract_id = pp.data_extract_id
540: and pa.assignment_type = 'ELEMENT'
541: and (pa.worksheet_id is null or pa.worksheet_id = p_worksheet_id)

Line 850: from PSB_PARAMETER_FORMULAS

846: element_value_type,
847: element_value,
848: effective_start_date,
849: effective_end_date
850: from PSB_PARAMETER_FORMULAS
851: where parameter_id = p_parameter_id
852: order by step_number;
853:
854: BEGIN

Line 1275: from PSB_PARAMETER_FORMULAS

1271:
1272: cursor c_Formula is
1273: select increment_by,
1274: increment_type
1275: from PSB_PARAMETER_FORMULAS
1276: where parameter_id = p_parameter_id;
1277:
1278: cursor c_ElemRates is
1279: select a.pay_element_id,

Line 2426: from PSB_PARAMETER_FORMULAS

2422: element_value_type,
2423: element_value,
2424: effective_start_date,
2425: effective_end_date
2426: from PSB_PARAMETER_FORMULAS
2427: where parameter_id = p_parameter_id
2428: order by step_number;
2429:
2430: BEGIN

Line 2951: from PSB_PARAMETER_FORMULAS

2947: adjdate_between_from,
2948: adjdate_between_to,
2949: increment_by,
2950: increment_type
2951: from PSB_PARAMETER_FORMULAS
2952: where parameter_id = p_parameter_id;
2953:
2954: BEGIN
2955: