APPS.ASG_DOWNLOAD dependencies on ASG_USER_PUB_RESPS

Line 1894: FROM asg_user_pub_resps

1890:
1891: INSERT INTO asg_purge_sdq(user_name,pub_name,creation_date,created_by,
1892: last_update_date,last_updated_by )
1893: ( SELECT user_name,pub_name ,sysdate,1,sysdate,1
1894: FROM asg_user_pub_resps
1895: WHERE user_name = l_user_name
1896: AND pub_name IN
1897: (select name from asg_pub where nvl(custom,'N') = 'N' )
1898: );

Line 1966: FROM asg_user_pub_resps

1962: l_last_processed VARCHAR2,l_max_num NUMBER,
1963: l_last_user varchar2)
1964: IS
1965: SELECT user_name,pub_name
1966: FROM asg_user_pub_resps
1967: WHERE trunc( sysdate - NVL(synch_date,to_date('1', 'J')) )
1968: > l_dormancy_period
1969: AND pub_name IN ( SELECT NAME FROM asg_pub WHERE nvl(custom,'N') = 'N' )
1970: and user_name > l_last_processed

Line 2005: FROM asg_user_pub_resps

2001: SELECT user_name FROM (
2002: SELECT ROWNUM pos,user_name FROM
2003: (
2004: SELECT DISTINCT user_name
2005: FROM asg_user_pub_resps
2006: WHERE user_name > l_last_processed
2007: AND TRUNC( SYSDATE - NVL(synch_date,TO_DATE('1', 'J')) )
2008: > l_dormancy_period
2009: ORDER BY user_name

Line 2020: FROM asg_user_pub_resps

2016: SELECT COUNT(*) FROM (
2017: SELECT ROWNUM pos,user_name FROM
2018: (
2019: SELECT DISTINCT user_name
2020: FROM asg_user_pub_resps
2021: WHERE user_name > l_last_processed
2022: AND TRUNC( SYSDATE - NVL(synch_date,TO_DATE('1', 'J')) )
2023: > l_dormancy_period
2024: ORDER BY user_name