APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_PGM_F

Line 1534: hr_utility.set_location(' BEN_PGM_F CREATE_PROGRAM ',20);

1530: hr_utility.set_location('l_sal_upd_cd is'||l_sal_upd_cd,4);
1531: if l_pgm_id is null and r_pgm.dml_operation = 'INSERT' then
1532: hr_utility.set_location('dflt_step '||l_dflt_step_cd,1);
1533: hr_utility.set_location('sal_upd '||l_sal_upd_cd,2);
1534: hr_utility.set_location(' BEN_PGM_F CREATE_PROGRAM ',20);
1535: begin
1536: BEN_PROGRAM_API.CREATE_PROGRAM(
1537: P_EFFECTIVE_DATE => l_effective_date
1538: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 1645: hr_utility.set_location(' BEN_PGM_F UPDATE_PROGRAM ',30);

1641: p_ptip_id => l_ptip_id);
1642: hr_utility.set_location('pgm writeback comp ',3);
1643: --
1644: elsif r_pgm.dml_operation ='UPDATE' and l_pgm_id is not null then
1645: hr_utility.set_location(' BEN_PGM_F UPDATE_PROGRAM ',30);
1646: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
1647: if p_datetrack_mode <> 'CORRECTION' then
1648: l_dt_mode := get_update_mode(p_table_name => 'BEN_PGM_F',
1649: p_key_column_name => 'PGM_ID',

Line 1648: l_dt_mode := get_update_mode(p_table_name => 'BEN_PGM_F',

1644: elsif r_pgm.dml_operation ='UPDATE' and l_pgm_id is not null then
1645: hr_utility.set_location(' BEN_PGM_F UPDATE_PROGRAM ',30);
1646: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
1647: if p_datetrack_mode <> 'CORRECTION' then
1648: l_dt_mode := get_update_mode(p_table_name => 'BEN_PGM_F',
1649: p_key_column_name => 'PGM_ID',
1650: p_key_column_value => l_pgm_id,
1651: p_effective_date => l_effective_date);
1652: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

Line 1656: l_db_ovn := get_ovn(p_table_name => 'BEN_PGM_F',

1652: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
1653: else
1654: l_dt_mode := p_datetrack_mode;
1655: end if;
1656: l_db_ovn := get_ovn(p_table_name => 'BEN_PGM_F',
1657: p_key_column_name => 'PGM_ID',
1658: p_key_column_value => l_pgm_id,
1659: p_effective_date => l_effective_date);
1660: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 3665: l_pgm_name ben_pgm_f.NAME%TYPE;

3661: end stage_to_vpf;
3662: FUNCTION get_pgm_name (p_pgm_id IN NUMBER, p_effective_date IN DATE)
3663: RETURN VARCHAR2
3664: IS
3665: l_pgm_name ben_pgm_f.NAME%TYPE;
3666: BEGIN
3667: SELECT NAME
3668: INTO l_pgm_name
3669: FROM ben_pgm_f

Line 3669: FROM ben_pgm_f

3665: l_pgm_name ben_pgm_f.NAME%TYPE;
3666: BEGIN
3667: SELECT NAME
3668: INTO l_pgm_name
3669: FROM ben_pgm_f
3670: WHERE pgm_id = p_pgm_id
3671: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
3672:
3673: RETURN l_pgm_name;

Line 3782: FROM ben_pgm_f

3778:
3779: CURSOR csr_pgm_details (eff_date IN DATE)
3780: IS
3781: SELECT pgm_id
3782: FROM ben_pgm_f
3783: WHERE business_group_id = p_business_group_id
3784: AND pgm_typ_cd = 'GSP'
3785: AND eff_date BETWEEN effective_start_date AND effective_end_date;
3786:

Line 3790: from ben_pgm_f

3786:
3787: Cursor csr_pgm_start_date(p_program_id in number)
3788: is
3789: select min(effective_start_date)
3790: from ben_pgm_f
3791: where pgm_id = p_program_id;
3792:
3793: l_ler_id NUMBER;
3794: l_effective_date DATE;