DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 34: g_ledger_id ap_system_parameters_all.set_of_books_id%type ;

30: /*------------------------------------------------------------------------------------------------------------------------*/
31: -- GLOBAL DECLARATION
32: /*------------------------------------------------------------------------------------------------------------------------*/
33:
34: g_ledger_id ap_system_parameters_all.set_of_books_id%type ;
35: g_org_id ap_system_parameters_all.org_id%type;
36: g_period_name gl_periods.period_name%type;
37: g_period_start_date gl_period_statuses.start_date%type;
38: g_period_end_date gl_period_statuses.end_date%type;

Line 35: g_org_id ap_system_parameters_all.org_id%type;

31: -- GLOBAL DECLARATION
32: /*------------------------------------------------------------------------------------------------------------------------*/
33:
34: g_ledger_id ap_system_parameters_all.set_of_books_id%type ;
35: g_org_id ap_system_parameters_all.org_id%type;
36: g_period_name gl_periods.period_name%type;
37: g_period_start_date gl_period_statuses.start_date%type;
38: g_period_end_date gl_period_statuses.end_date%type;
39: g_action varchar2 (30);

Line 68: ,ap_system_parameters_all aspa

64: , aspa.recon_accounting_flag
65: , aspa.when_to_account_pmt
66: , aspa.set_of_books_id
67: from hr_operating_units hou
68: ,ap_system_parameters_all aspa
69: where aspa.org_id = hou.organization_id
70: and ( ( g_ledger_id is not null and aspa.set_of_books_id = g_ledger_id)
71: and (g_org_id is null OR (g_org_id is not null and aspa.org_id = g_org_id))
72: )