DBA Data[Home] [Help]

APPS.PN_VAREN_PVT dependencies on PN_SYSTEM_SETUP_OPTIONS

Line 5983: l_auto_var_rent_num pn_system_setup_options.auto_var_rent_num_gen%TYPE;

5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
5980: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
5981: l_comments pn_var_templates_all.comments%TYPE;
5982: l_auto_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
5983: l_auto_var_rent_num pn_system_setup_options.auto_var_rent_num_gen%TYPE;
5984:
5985: l_proration_days NUMBER;
5986: l_location_id NUMBER;
5987: BEGIN

Line 6144: FROM pn_system_setup_options

6140:
6141: --check the system profile option
6142: SELECT auto_var_rent_num_gen
6143: INTO l_auto_var_rent_num
6144: FROM pn_system_setup_options
6145: WHERE org_id = g_org_id;
6146:
6147: IF (l_auto_var_rent_num = 'Y')
6148: THEN