APPS.PSP_PAYTRN dependencies on PAY_ELEMENT_ENTRIES_F

Line 283: from pay_element_entries_f pee

279: pay_input_values_f piv
280: WHERE a.assignment_action_id = l_assignment_action_id and
281: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
282: not exists ( select null
283: from pay_element_entries_f pee
284: where pee.element_entry_id = b.source_id and
285: pee.creator_type in ('RR','EE')) and
286: a.balance_or_cost = 'C' and
287: NVL(a.costed_value,0) <> 0 and

Line 325: from pay_element_entries_f pee

321: pay_input_values_f piv
322: WHERE a.assignment_action_id = l_assignment_action_id and
323: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
324: exists ( select null
325: from pay_element_entries_f pee
326: where pee.element_entry_id = b.source_id and
327: pee.creator_type in ('RR','EE')) and
328: a.balance_or_cost = 'C' and
329: NVL(a.costed_value,0) <> 0 and

Line 517: FROM pay_element_entries_f

513: l_clearing_account_value VARCHAR2(1000);
514:
515: CURSOR ee_date_earned_cur IS
516: SELECT effective_start_date, effective_end_date,date_earned --LD Dev
517: FROM pay_element_entries_f
518: WHERE element_entry_id = g_pay_costs_rec.source_id;
519:
520: CURSOR emphours_config_cur IS
521: SELECT DECODE(pcv_information1, 'Y', 'H', 'M') employee_hours

Line 969: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||

965: IF (l_aw_column IS NOT NULL) THEN
966: BEGIN
967: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
968: l_tk_column || ', ' || l_aw_column || ', ' || l_eo_column || ', ' || l_et_column ||
969: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
970: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
971: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
972: USING g_pay_costs_rec.date_earned;
973: EXCEPTION

Line 981: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||

977: ELSE
978: BEGIN
979: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
980: l_tk_column || ', ' || l_eo_column || ', ' || l_et_column ||
981: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
982: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
983: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
984: USING g_pay_costs_rec.date_earned;
985: EXCEPTION

Line 993: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||

989: END IF;
990: ELSIF (l_gl_column IS NOT NULL) THEN
991: BEGIN
992: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column ||
993: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
994: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
995: INTO l_or_gl_ccid
996: USING g_pay_costs_rec.date_earned;
997: EXCEPTION

Line 1006: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||

1002: IF (l_aw_column IS NOT NULL) THEN
1003: BEGIN
1004: EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
1005: l_aw_column || ', ' || l_eo_column || ', ' || l_et_column ||
1006: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||
1007: g_pay_costs_rec.source_id ||
1008: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
1009: INTO l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
1010: USING g_pay_costs_rec.date_earned;

Line 1019: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||

1015: ELSE
1016: BEGIN
1017: EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
1018: l_eo_column || ', ' || l_et_column ||
1019: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||
1020: g_pay_costs_rec.source_id ||
1021: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
1022: INTO l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
1023: USING g_pay_costs_rec.date_earned;