APPS.ASG_DOWNLOAD dependencies on ASG_USER_PUB_RESPS

Line 1896: FROM asg_user_pub_resps

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

Line 1968: FROM asg_user_pub_resps

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

Line 2007: FROM asg_user_pub_resps

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

Line 2022: FROM asg_user_pub_resps

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