APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on ZX_REGISTRATIONS

Line 8: g_state_insc_tax_regime zx_registrations.tax_regime_code%TYPE;

4: l_cc_exists_flag number :=1; -- cost center setup flag. it will become zero if cost center setup not done in intialize proc.
5: l_exclusive_mode VARCHAR2(1);
6: l_estb_acts_as_company VARCHAR2(1); -- This flag explains whethere LE is acting as company or Establishment is acting as company
7: -- Will populate this flag with 'Y' , if accounting_type is 'CENTRALIZED' and establishment_id is not null.
8: g_state_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
9: g_state_insc_tax zx_registrations.tax%TYPE;
10: g_municipal_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
11: g_municipal_insc_tax zx_registrations.tax%TYPE;
12:

Line 9: g_state_insc_tax zx_registrations.tax%TYPE;

5: l_exclusive_mode VARCHAR2(1);
6: l_estb_acts_as_company VARCHAR2(1); -- This flag explains whethere LE is acting as company or Establishment is acting as company
7: -- Will populate this flag with 'Y' , if accounting_type is 'CENTRALIZED' and establishment_id is not null.
8: g_state_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
9: g_state_insc_tax zx_registrations.tax%TYPE;
10: g_municipal_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
11: g_municipal_insc_tax zx_registrations.tax%TYPE;
12:
13: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE );

Line 10: g_municipal_insc_tax_regime zx_registrations.tax_regime_code%TYPE;

6: l_estb_acts_as_company VARCHAR2(1); -- This flag explains whethere LE is acting as company or Establishment is acting as company
7: -- Will populate this flag with 'Y' , if accounting_type is 'CENTRALIZED' and establishment_id is not null.
8: g_state_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
9: g_state_insc_tax zx_registrations.tax%TYPE;
10: g_municipal_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
11: g_municipal_insc_tax zx_registrations.tax%TYPE;
12:
13: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE );
14: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE );

Line 11: g_municipal_insc_tax zx_registrations.tax%TYPE;

7: -- Will populate this flag with 'Y' , if accounting_type is 'CENTRALIZED' and establishment_id is not null.
8: g_state_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
9: g_state_insc_tax zx_registrations.tax%TYPE;
10: g_municipal_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
11: g_municipal_insc_tax zx_registrations.tax%TYPE;
12:
13: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE );
14: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE );
15: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,

Line 1656: FROM zx_registrations reg,

1652: BEGIN -- retreive state inscription
1653:
1654: SELECT reg.registration_number
1655: INTO l_state_inscription
1656: FROM zx_registrations reg,
1657: xle_etb_profiles etb,
1658: zx_party_tax_profile ptp
1659: WHERE etb.legal_entity_id = g_legal_entity_id
1660: AND main_establishment_flag = 'Y' -- will fetch the registration number of main establishment for LE in case of EBtax.

Line 1682: FROM zx_registrations reg,

1678: BEGIN -- retreive municipal inscription
1679:
1680: SELECT reg.registration_number
1681: INTO l_municipal_inscription
1682: FROM zx_registrations reg,
1683: xle_etb_profiles etb,
1684: zx_party_tax_profile ptp
1685: WHERE etb.legal_entity_id = g_legal_entity_id
1686: AND main_establishment_flag = 'Y' -- will fetch the registration number of main establishment for LE in case of EBtax.

Line 1810: FROM zx_registrations reg,

1806: BEGIN -- retreive state inscription
1807:
1808: SELECT reg.registration_number
1809: INTO l_state_inscription
1810: FROM zx_registrations reg,
1811: xle_etb_profiles etb,
1812: zx_party_tax_profile ptp
1813: WHERE etb.legal_entity_id = g_legal_entity_id
1814: AND etb.establishment_id = g_establishment_id

Line 1834: FROM zx_registrations reg,

1830: BEGIN -- retreive municipal inscription
1831:
1832: SELECT reg.registration_number
1833: INTO l_municipal_inscription
1834: FROM zx_registrations reg,
1835: xle_etb_profiles etb,
1836: zx_party_tax_profile ptp
1837: WHERE etb.legal_entity_id = g_legal_entity_id
1838: AND etb.establishment_id = g_establishment_id

Line 2335: FROM zx_registrations reg,

2331: BEGIN -- retreive state inscription
2332:
2333: SELECT reg.registration_number
2334: INTO l_state_inscription
2335: FROM zx_registrations reg,
2336: xle_etb_profiles etb,
2337: zx_party_tax_profile ptp
2338: WHERE etb.legal_entity_id = g_legal_entity_id
2339: AND main_establishment_flag = 'Y' -- will fetch the registration number of main establishment for LE in case of EBtax.

Line 2361: FROM zx_registrations reg,

2357: BEGIN -- retreive municipal inscription
2358:
2359: SELECT reg.registration_number
2360: INTO l_municipal_inscription
2361: FROM zx_registrations reg,
2362: xle_etb_profiles etb,
2363: zx_party_tax_profile ptp
2364: WHERE etb.legal_entity_id = g_legal_entity_id
2365: AND main_establishment_flag = 'Y' -- will fetch the registration number of main establishment for LE in case of EBtax.

Line 2622: FROM zx_registrations reg,

2618: BEGIN -- retreive state inscription
2619:
2620: SELECT reg.registration_number
2621: INTO l_state_inscription
2622: FROM zx_registrations reg,
2623: xle_etb_profiles etb,
2624: zx_party_tax_profile ptp
2625: WHERE etb.legal_entity_id = g_legal_entity_id
2626: AND etb.establishment_id = l_establishment_id -- will fetch the registration number of main establishment for LE in case of EBtax.

Line 2646: FROM zx_registrations reg,

2642: BEGIN -- retreive municipal inscription
2643:
2644: SELECT reg.registration_number
2645: INTO l_municipal_inscription
2646: FROM zx_registrations reg,
2647: xle_etb_profiles etb,
2648: zx_party_tax_profile ptp
2649: WHERE etb.legal_entity_id = g_legal_entity_id
2650: AND etb.establishment_id = l_establishment_id -- will fetch the registration number of main establishment for LE in case of EBtax.