eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_TAXES

Line 1942: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is

1938: p_process_message out nocopy varchar2
1939: )
1940: is
1941:
1942: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is
1943: select tax_id
1944: from jai_ap_tds_thhold_taxes
1945: where threshold_slab_id = p_threshold_slab_id
1946: and operating_unit_id = p_org_id;

Line 1944: from jai_ap_tds_thhold_taxes

1940: is
1941:
1942: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is
1943: select tax_id
1944: from jai_ap_tds_thhold_taxes
1945: where threshold_slab_id = p_threshold_slab_id
1946: and operating_unit_id = p_org_id;
1947:
1948:

Line 1979: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;

1975:
1976: lv_codepath jai_ap_tds_inv_taxes.codepath%type;
1977:
1978:
1979: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
1980: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
1981: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
1982:
1983: ln_thhold_transition_tax_amt number;

Line 1992: open c_jai_ap_tds_thhold_taxes(p_threshold_slab_id, p_org_id);

1988: ln_threshold_grp_id number;
1989:
1990: begin
1991:
1992: open c_jai_ap_tds_thhold_taxes(p_threshold_slab_id, p_org_id);
1993: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1994: close c_jai_ap_tds_thhold_taxes;
1995:
1996: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);

Line 1993: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;

1989:
1990: begin
1991:
1992: open c_jai_ap_tds_thhold_taxes(p_threshold_slab_id, p_org_id);
1993: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1994: close c_jai_ap_tds_thhold_taxes;
1995:
1996: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
1997: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

Line 1994: close c_jai_ap_tds_thhold_taxes;

1990: begin
1991:
1992: open c_jai_ap_tds_thhold_taxes(p_threshold_slab_id, p_org_id);
1993: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1994: close c_jai_ap_tds_thhold_taxes;
1995:
1996: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
1997: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1998: close c_jai_ap_tds_thhold_grps;

Line 2000: open c_ja_in_tax_codes(r_jai_ap_tds_thhold_taxes.tax_id);

1996: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
1997: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1998: close c_jai_ap_tds_thhold_grps;
1999:
2000: open c_ja_in_tax_codes(r_jai_ap_tds_thhold_taxes.tax_id);
2001: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;
2002: close c_ja_in_tax_codes;
2003:
2004: -- Bug 5722028. Added by csahoo

Line 2028: pn_tax_id => r_jai_ap_tds_thhold_taxes.tax_id ,

2024: pn_invoice_id => p_invoice_id ,
2025: pn_taxable_amount => null ,
2026: /* No taxable amount in case of threshold transition invoice */
2027: pn_tax_amount => ln_thhold_transition_tax_amt ,
2028: pn_tax_id => r_jai_ap_tds_thhold_taxes.tax_id ,
2029: pd_accounting_date => p_accounting_date ,
2030: pv_tds_event => p_tds_event ,
2031: pn_threshold_grp_id => p_threshold_grp_id ,
2032: pv_tds_invoice_num => lv_tds_invoice_num ,

Line 3448: FROM jai_ap_tds_thhold_taxes a,

3444: IS
3445: SELECT b.tax_rate,
3446: b.from_amount,
3447: a.tax_id
3448: FROM jai_ap_tds_thhold_taxes a,
3449: jai_ap_tds_thhold_slabs b
3450: WHERE a.threshold_slab_id = b.threshold_slab_id
3451: AND a.operating_unit_id = p_org_id
3452: AND b.threshold_slab_id = p_threshold_slab_id;