DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 29: g_ledger_id ap_system_parameters_all.set_of_books_id%type ;

25: /*------------------------------------------------------------------------------------------------------------------------*/
26: -- GLOBAL DECLARATION
27: /*------------------------------------------------------------------------------------------------------------------------*/
28:
29: g_ledger_id ap_system_parameters_all.set_of_books_id%type ;
30: g_org_id ap_system_parameters_all.org_id%type;
31: g_period_name gl_periods.period_name%type;
32: g_period_start_date gl_period_statuses.start_date%type;
33: g_period_end_date gl_period_statuses.end_date%type;

Line 30: g_org_id ap_system_parameters_all.org_id%type;

26: -- GLOBAL DECLARATION
27: /*------------------------------------------------------------------------------------------------------------------------*/
28:
29: g_ledger_id ap_system_parameters_all.set_of_books_id%type ;
30: g_org_id ap_system_parameters_all.org_id%type;
31: g_period_name gl_periods.period_name%type;
32: g_period_start_date gl_period_statuses.start_date%type;
33: g_period_end_date gl_period_statuses.end_date%type;
34: g_action varchar2 (30);

Line 63: ,ap_system_parameters_all aspa

59: , aspa.recon_accounting_flag
60: , aspa.when_to_account_pmt
61: , aspa.set_of_books_id
62: from hr_operating_units hou
63: ,ap_system_parameters_all aspa
64: where aspa.org_id = hou.organization_id
65: and ( ( g_ledger_id is not null and aspa.set_of_books_id = g_ledger_id)
66: and (g_org_id is null OR (g_org_id is not null and aspa.org_id = g_org_id))
67: )