DBA Data[Home] [Help]

APPS.PA_ADJUSTMENTS dependencies on PA_IMPLEMENTATIONS

Line 9379: l_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;

9375: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
9376: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
9377: l_rate_sch_id pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE;
9378: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
9379: l_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
9380: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
9381: l_ot_project_id pa_projects_all.project_id%TYPE;
9382: l_ot_task_id pa_tasks.task_id%TYPE;
9383: l_err_stage number;

Line 9552: , PA_IMPLEMENTATIONS IMP

9548: CURSOR C_SOB_COA_CUR IS
9549: SELECT IMP.SET_OF_BOOKS_ID
9550: , GL.CHART_OF_ACCOUNTS_ID
9551: FROM GL_LEDGERS_PUBLIC_V GL
9552: , PA_IMPLEMENTATIONS IMP
9553: WHERE GL.LEDGER_ID = IMP.SET_OF_BOOKS_ID;
9554:
9555: /* this cursor gets the vendor id of the employee for which the ER was entered */
9556: CURSOR C_VENDOR_ID_CUR(p_emp_id NUMBER) IS

Line 10759: pa_implementations imp

10755:
10756: CURSOR c_rep_curr_or_sec_ledger is
10757: SELECT COUNT(*)
10758: FROM gl_ledgers_v gl,
10759: pa_implementations imp
10760: WHERE imp.set_of_books_id = gl.ledger_id
10761: AND (EXISTS
10762: (SELECT NULL
10763: FROM gl_secondary_ledger_rships_v sl,