DBA Data[Home] [Help]

APPS.PA_ADJUSTMENTS dependencies on PA_IMPLEMENTATIONS

Line 9662: l_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;

9658: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
9659: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
9660: l_rate_sch_id pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE;
9661: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
9662: l_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
9663: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
9664: l_ot_project_id pa_projects_all.project_id%TYPE;
9665: l_ot_task_id pa_tasks.task_id%TYPE;
9666: l_err_stage number;

Line 9835: , PA_IMPLEMENTATIONS IMP

9831: CURSOR C_SOB_COA_CUR IS
9832: SELECT IMP.SET_OF_BOOKS_ID
9833: , GL.CHART_OF_ACCOUNTS_ID
9834: FROM GL_LEDGERS_PUBLIC_V GL
9835: , PA_IMPLEMENTATIONS IMP
9836: WHERE GL.LEDGER_ID = IMP.SET_OF_BOOKS_ID;
9837:
9838: /* this cursor gets the vendor id of the employee for which the ER was entered */
9839: CURSOR C_VENDOR_ID_CUR(p_emp_id NUMBER) IS

Line 11088: pa_implementations imp

11084:
11085: CURSOR c_rep_curr_or_sec_ledger is
11086: SELECT COUNT(*)
11087: FROM gl_ledgers_v gl,
11088: pa_implementations imp
11089: WHERE imp.set_of_books_id = gl.ledger_id
11090: AND (EXISTS
11091: (SELECT NULL
11092: FROM gl_secondary_ledger_rships_v sl,