APPS.PSP_ENC_PRE_PROCESS dependencies on PSP_ORGANIZATION_ACCOUNTS

Line 956: dates in psp_organization_accounts for poeta CI. It inserts assignments in

952:
953: /****************************************************************************************************
954: Procedure Name: UPDATE_DEFAULT_SUSP_ACCOUNTS
955: Purpose: This procedure is called in the main procedure and used for updating poeta
956: dates in psp_organization_accounts for poeta CI. It inserts assignments in
957: psp_enc_changed_assignments table if the poeta dates are different from
958: previous poeta dates and assignments exists in psp_enc_lines_history
959: table.
960: ****************************************************************************************************/

Line 1002: FROM psp_organization_accounts poa

998: poa.start_date_active,
999: poa.end_date_active,
1000: NVL(poa.poeta_start_date,TO_DATE('01-01-1800', 'DD-MM-YYYY')) poeta_start_date,
1001: NVL(poa.poeta_end_date,TO_DATE('31-12-4712', 'DD-MM-YYYY')) poeta_end_date
1002: FROM psp_organization_accounts poa
1003: WHERE poa.gl_code_combination_id IS NULL
1004: AND poa.end_date_active >= p_max_pay_date
1005: AND poa.business_group_id = p_business_group_id
1006: AND poa.set_of_books_id = p_set_of_books_id

Line 1157: /* Updating poeta dates in psp_organization_accounts */

1153: -- Introduced for bug fix 3434626
1154: l_proc_step := 60;
1155: -- End of bug fix 3434626
1156:
1157: /* Updating poeta dates in psp_organization_accounts */
1158: FORALL i IN 1 .. g_total_num_rec
1159: UPDATE psp_organization_accounts
1160: SET poeta_end_date = r_susp_control_rec.r_poeta_end_date(i),
1161: poeta_start_date = r_susp_control_rec.r_poeta_start_date(i)

Line 1159: UPDATE psp_organization_accounts

1155: -- End of bug fix 3434626
1156:
1157: /* Updating poeta dates in psp_organization_accounts */
1158: FORALL i IN 1 .. g_total_num_rec
1159: UPDATE psp_organization_accounts
1160: SET poeta_end_date = r_susp_control_rec.r_poeta_end_date(i),
1161: poeta_start_date = r_susp_control_rec.r_poeta_start_date(i)
1162: WHERE organization_account_id = r_susp_control_rec.r_organization_account_id(i);
1163:

Line 1751: psp_organization_accounts poa

1747: SELECT DISTINCT pelh.assignment_id,
1748: pelh.payroll_id
1749: FROM psp_enc_lines_history pelh,
1750: per_assignments_f paf,
1751: psp_organization_accounts poa
1752: WHERE pelh.suspense_org_account_id = poa.organization_account_id
1753: AND poa.organization_id = l_generic_suspense
1754: AND pelh.change_flag = 'N'
1755: AND pelh.assignment_id = paf.assignment_id