APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PER_IMAGES

Line 1478: lblob_image per_images.image%TYPE;

1474: lr_proc_info lcu_proc_info%ROWTYPE;
1475: lr_emp_add_info lcu_emp_add_info%ROWTYPE;
1476: --Local Variables
1477: ln_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1478: lblob_image per_images.image%TYPE;
1479: lc_xml CLOB;
1480: lc_xml2 CLOB;
1481: lc_common_xml CLOB;
1482: lc_xml_begin VARCHAR2(200);

Line 1935: FROM per_images PIMG

1931: CURSOR lcu_get_image(p_assignment_id NUMBER)
1932: IS
1933: SELECT PIMG.parent_id
1934: ,PIMG.image
1935: FROM per_images PIMG
1936: WHERE PIMG.parent_id = (SELECT DISTINCT PPF.person_id
1937: FROM per_assignments_f PPF
1938: WHERE PPF.assignment_id = p_assignment_id
1939: );

Line 1948: lblob_image per_images.image%TYPE;

1944: FROM per_jp_empdet_emp_v PJEDV
1945: WHERE PJEDV.assignment_action_id = p_mag_asg_action_id;
1946: --
1947: l_final_xml_string CLOB;
1948: lblob_image per_images.image%TYPE;
1949: lc_xml_string1 VARCHAR2(2000);
1950: lc_proc_name VARCHAR2(60);
1951: lc_legislative_parameters VARCHAR(2000);
1952: ln_assignment_id NUMBER;